22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM TB T WHERE EXISTS(SELECT 1 FROM TB WHERE NAME=T.NAME AND ID<>T.ID)
select [name],count(*) from [user]
group by [name]
having count(*)>1
select * from tb where name in(select name from tb group by name having count(1)>1)
select name from tb group by name having count(1)>1