select * from tablename where id in (
select id from tablename group by id having count(id) > 1 )本文共 152 字，大约阅读时间需要 1 分钟。
select * from tablename where id in (
select id from tablename group by id having count(id) > 1 )转载于:https://www.cnblogs.com/jiayongchao/p/4271980.html