**查找表中多余重复记录并删除保留最小一个**
select * from 表名 where (字段1,字段2) in(select 字段1,字段2
from 表名group by 字段1, 字段2 having count(*) > 1);
**能查出来的话, 删除表中多余的重复记录(多个字段),只留有rowid最小的记录**
delete from 表名 where (字段1,字段2) in (select 字段1,字段2 from 表名 group by 字段1,字段2 having count(*) > 1) and rowid not in (select min(rowid) from 表名 group by 字段1,字段2 having count(*)>1)