delete
from tablename a
where rowid > ( select min(rowid)
from table_name b
where b.id = a.id and b.name=a.name);
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