SQl重复记录查询的几种方法

1、查找表中重复记录，根据单个字段来判断

Select * from tableA where peopleId in(select peopleId from tableA group by peopleI having count (peopleId)>1)

2、查找表中重复记录，根据多个字段判断

Select * from tableA as A where (A.peopleId,A.seq) in (select peopleId,seq from tableA group by peopleId,seq having count (*)>1)