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.sew) in (select peopleId,seq from tableA group by peopleI,seq having count (*)>1)

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

原文：http://www.cnblogs.com/hexiaoping/p/7810792.html