select * from people where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
select * from people where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
转载于:https://www.cnblogs.com/macT/p/10865219.html