sql查询重复记录

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

		

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

		

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