delete from table_name a where rowid <
(select max(rowid) from table_name b
where a.col1 = b.col1
and a.col2 = b.col2 -- 遍历所以数据,以确定重复纪录
)
转载于:https://www.cnblogs.com/wanghang/p/6299410.html
delete from table_name a where rowid <
(select max(rowid) from table_name b
where a.col1 = b.col1
and a.col2 = b.col2 -- 遍历所以数据,以确定重复纪录
)
转载于:https://www.cnblogs.com/wanghang/p/6299410.html