一般是这样操作的 查询重复NAME: select NAME from 表A group by NAME having conunt(NAME) > 1 查询有重复NAME的信息信息 select NAME,UID from 表A where NAME in ( select NAME from 表A group by NAME having conunt(NAME) > 1 ) order by NAME
第2个回答 2013-08-22
select * from 表名 where name in (select name from 表名 group by name having count(*)>1)
这个意思?
第3个回答 2013-08-22
select * from table name in (select name from table group by name having count(UID)>1 )本回答被提问者采纳