SQL重复记录查询删除

1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断

复制代码代码如下:

select * from content
where 标题 in (select   标题 from   content group by  标题 having count

(标题) > 1)

2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录

复制代码代码如下:

delete from content 
where 标题 in (select   标题 from people group by   标题   having count

(标题) > 1)
and rowid not in (select min(rowid) from  content group by 标题 having count(标题

)>1)