重复列是id 表名是tab 则
delete from tab a where a.rowid!=(select min(b.rowid) from tab b where b.id=a.id);
delete from tab a where a.rowid!=(select min(b.rowid) from tab b where b.id=a.id);
调试欢乐多
你会看到rowid 是不一样的,根据rowid来确定删除的行
delete from tablename where rowid =.....