delete from tablename a where rowid > ( select min(rowid) from table_name b where b.id = a.id and b.name=a.name);
本文共 174 字，大约阅读时间需要 1 分钟。
delete from tablename a where rowid > ( select min(rowid) from table_name b where b.id = a.id and b.name=a.name);
转载于:https://www.cnblogs.com/vitre/p/5504950.html