SQL语句

 参考 

http://t.zoukankan.com/lidabo-p-3024708.html

1、查找表people中字段（peopleId）重复的记录 

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