1、 利用rowid删除重复的数据
delete from tbl a where rowid<(select max(b.rowid) from tbl b where a.col1=b.col1 and a.col2 = b.col2);
//这里如果把max换成min的话,前面的where子句中需要把"<"改为">"
1、 利用rowid删除重复的数据
delete from tbl a where rowid<(select max(b.rowid) from tbl b where a.col1=b.col1 and a.col2 = b.col2);
//这里如果把max换成min的话,前面的where子句中需要把"<"改为">"