select id from user where (select count(*) from user where name ='+name+') > 1
SELECT A.ID,A.NAME FROM TABLE A,TABLE B WHERE A.NAME = B.NAME看看结果如何,看是否要DISTINCT
String strSQL = "select distinct a.ID,a.Name from Table as a,Table as b where a.Name=b.Name"
额 楼上2位这种写法 你起码 把 a.id <> b.id 加上吧
select id,count(name) from user group by name having count(name)>1
select a.id from a ,(select name from a group by name having count(1)>1) t where a.name=t.name
还要加个条件吧 select id, name from user where (select count(*) from user where name = '你想查看的名字') > 1 and name = '你想查看的名字'
select id,name from tbl where exists(select 1 from tbl b where b.id<>tbl.id and b.name=tbl.name)
select id from table where id_name in (select id_name from table b group by id_name having (count(*)) >1)
SQL 2005 create table Test (Id int identity(1,1),name varchar(50))insert into Test(name) values('Test1'); insert into Test(name) values('Test1'); insert into Test(name) values('Test2'); SELECT A.ID,A.NAME FROM Test A,Test B WHERE A.NAME = B.NAME and A.id<>B.id
FROM TABLE A,TABLE B
WHERE A.NAME = B.NAME看看结果如何,看是否要DISTINCT
你起码 把 a.id <> b.id 加上吧
group by name having count(name)>1
select a.id from a ,(select name from a group by name having count(1)>1) t where a.name=t.name
还要加个条件吧
select id, name
from user
where (select count(*) from user where name = '你想查看的名字') > 1
and name = '你想查看的名字'
create table Test (Id int identity(1,1),name varchar(50))insert into Test(name) values('Test1');
insert into Test(name) values('Test1');
insert into Test(name) values('Test2');
SELECT A.ID,A.NAME FROM Test A,Test B WHERE A.NAME = B.NAME and A.id<>B.id