81,095
社区成员
发帖
与我相关
我的任务
分享
select id, name
from user
where (select count(*) from user where name = '你想查看的名字') > 1
and name = '你想查看的名字'
select a.id from a ,(select name from a group by name having count(1)>1) t where a.name=t.name
String strSQL = "select distinct a.ID,a.Name from Table as a,Table as b where a.Name=b.Name"