查询语句，非常感谢！

[kimc]

tb
BH Name
1 电脑
2 电脑
3 桌子
4 电脑
5 球鞋
6 桌子
7 手机
8 桌子
9 足球

查询Name列中出现两次或两次以上的记录

[bbdx2523]

select bh,name from tb where ( select count(name) from tb ) > 1

[kimc]

t

[kimc]

快，，，

[Michael_javavb]

一楼不对的
我的答案：
SELECT tb.bh,tb.name
FROM tb,(select max(name) as name,count(name) as tcount
from tb
group by name
)as temp
WHERE tb.name = temp.name
and temp.tcount>1

[$扫地僧$]

select * from tb where name in (select name from tb group by name having count(*)>=2)

[Michael_javavb]

刚才还太复杂，但是最符合逻辑习惯，这个更简单
SELECT a.bh,a.name
FROM tb as a,tb as b
WHERE a.bh<>b.bh
and a.name = b.name
--只要你的bh是不重复的即可

[ReViSion]

select * from tb where name in (select name from tb group by name having count(*)>=2)

[zhanggao1]

select * from tb a where exists(select 'x' from tb b where b.name=a.name and b.id<a.id)

[Michael_javavb]

sorry，select地方该为
SELECT DISTINCT a.bh,a.name，否则会有重复记录

[lxw99]

declare @tbl table (BH varchar(10),Name varchar(10))
insert into @tbl
SELECT '1','电脑' union all
SELECT '2','电脑' union all
SELECT '3','桌子' union all
SELECT '4','电脑' union all
SELECT '5','球鞋' union all
SELECT '6','桌子' union all
SELECT '7','手机' union all
SELECT '8','桌子' union all
SELECT '9','足球'

SELECT
Name
FROM
@tbl
group by
Name
having count(*)>=2
-------------------
Name
电脑
桌子