数据库中删除重复数据

1. 查看数据库中多条重复数据

SELECT 字段,COUNT(*) FROM  表名  group by 字段 having count(字段)>1;

   2.更具单个字段保留rowid最小的记录，删除重复数据，保留一条

    如果需要多个值判断，添加多个字段

delete from 表名 where 字段 in 
(select 字段 from 表名 group by 字段 having count(字段) >1) 
and rowid not in (select min(rowid) from 表名 group by 字段 having count(字段)>1);