sql查询重复记录

时间：2015-5-20类别：数据库

sql查询重复记录

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


select * from people  where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)

2、查找表中多个字段的重复记录



select * from vitae a where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)

3、查某一列(或多列)的重复值(只可以查出重复记录的值，不能查出整个记录的信息)

查找stuid，stuname重复的记录


select stuid，stuname from stuinfo
group by stuid，stuname
having(count(*))>1

标签：