把A字段有两条以上的相同记录选出来
select * from tablename where a in (select uid from user group by uid having count(uid)> 1 )
发布时间: 2012-09-14 23:00:49 作者: rapoo
把A字段有两条以上的相同记录选出来
select * from tablename where a in (select uid from user group by uid having count(uid)> 1 )