select * from test where name in ( select name from test group by name having count(*)>1 )
select distinct * from test a where (select count(*) from test b where a.name=b.name ) >1
select name from tableneme where name is not null group by name having count(*) > 1 如果想显示所有字段,就用上段sql在作为自查询结果就行了。
select distinct A.name from test A,test B where (A.name = B.name and A.ID <> B.id)
这个嘛,一定要用到Having子句,下面这句包你满意! select Name from test group by Name having count(*)>1 或: select * from test where Name in (select Name from test group by Name having count(*)>1)
这个嘛,一定要用到having子句,下面这两个包您满意: select name from test group by name having count(*)>1
select * from test where name in (select name from test group by name having count(*)>1)
这个SQL 找出所有重复的NAME: SELECT name FROM test GROUP BY name HAVING (COUNT(name) > 1)如果要找出所有重复的记录,需要用子查询: SELECT * FROM test WHERE (name IN (SELECT name FROM tab_test GROUP BY name HAVING (COUNT(name) > 1)) )
这个SQL 找出所有重复的NAME: SELECT name FROM test GROUP BY name HAVING (COUNT(name) > 1)如果要找出所有重复的记录,需要用子查询: SELECT * FROM test WHERE (name IN (SELECT name FROM test GROUP BY name HAVING (COUNT(name) > 1)) )
但是您的回答并不是我想的!
我的意思是:我想把NAME有重复值的记录查出来,而没有重复的不显示,
from test
where name in (
select name
from test
group by name
having count(*)>1
)
where (select count(*) from test b where a.name=b.name ) >1
from tableneme
where name is not null
group by name
having count(*) > 1
如果想显示所有字段,就用上段sql在作为自查询结果就行了。
select Name from test
group by Name
having count(*)>1
或:
select * from test
where Name in (select Name from test group by Name having count(*)>1)
select name from test group by name having count(*)>1
select * from test
where name in (select name from test group by name having count(*)>1)
SELECT name FROM test GROUP BY name HAVING (COUNT(name) > 1)如果要找出所有重复的记录,需要用子查询:
SELECT * FROM test
WHERE (name IN
(SELECT name FROM tab_test GROUP BY name HAVING (COUNT(name) > 1))
)
SELECT name FROM test GROUP BY name HAVING (COUNT(name) > 1)如果要找出所有重复的记录,需要用子查询:
SELECT * FROM test
WHERE (name IN
(SELECT name FROM test GROUP BY name HAVING (COUNT(name) > 1))
)
热泪盈眶!
大家的回答我都实验过,全都好使;
除了"lyxinfo"略有小疑,
再次感谢!