摘要：查询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 阅读全文