如果要返回所有的记录是不是用这个好一点?只是讨论,不抢分!select * from b where id_code in (
select id_code from b group by id_code having count(1)>1)或:select * from b tem where exists (
select id_code from b group by id_code having count(1)>1 and id_code=tem.id_code)??
select id_code from b group by id_code having count(1)>1)或:select * from b tem where exists (
select id_code from b group by id_code having count(1)>1 and id_code=tem.id_code)??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货