select * from peoplewhere peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
本文共 173 字，大约阅读时间需要 1 分钟。
select * from peoplewhere peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
转载于:https://my.oschina.net/u/3238650/blog/1788968