delete from tablename where UUID in ( select UUID from tablename where UUID not in (select min(UUID) UUID from tablename )) 你测试下,应该可以了
delete from table where rowid in ( select rowid from( select rowid, row_number() over(partition by 相同的字段 order by UUID desc) rn from table where rn>1))
( select UUID from tablename where UUID not in
(select min(UUID) UUID from tablename ))
你测试下,应该可以了
( select rowid from(
select rowid,
row_number() over(partition by 相同的字段 order by UUID desc) rn
from table where rn>1))