这个东西查了好久!下面的例子是:删除id和name完全一样的记录,只保留rowid最小的那一条
delete from user_ where id in (select id from user_ group by id,name having count(*)>1)
and rowid not in
(select min(rowid) from user_ group by name having count(*)>1)这个东西查了好久!下面的例子是:删除id和name完全一样的记录,只保留rowid最小的那一条
delete from user_ where id in (select id from user_ group by id,name having count(*)>1)
and rowid not in
(select min(rowid) from user_ group by name having count(*)>1)