查询A表中id的值相同的数据
select * from A a where exists (select id from A where id=a.id group by id having count(*)>1) ORDER BY id
查询A表中id的值相同的数据
select * from A a where exists (select id from A where id=a.id group by id having count(*)>1) ORDER BY id
转载于:https://www.cnblogs.com/ms2017/p/6559709.html