SQL重复记录查询的几种方法，需要的朋友可以参考一下
1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断
复制代码 代码如下:
select * from people
where peopleId in (select peopleId from people group by peopleId having count
(peopleId) > 1)
以上就是SQL重复记录查询的几种方法的详细内容，更多请关注0133技术站其它相关文章！
select * from people
where peopleId in (select peopleId from people group by peopleId having count
