搜索重复的字段？？？？？SQL语句怎么写

[loye]

在一张表里有USER字段，我要搜索重复的USER，怎样写SQL语句

[xinliangyu]

select * from 表名 where count(user)>1 group by user

[dqjia]

用count()函数

[yesterday2000]

select * from table where user in (

select max(user) from table
where having count(*)>1)

[loye]

不行啊，我都试过了

[yesterday2000]

select * from table where user in (

select max(user) from table
group by user
having count(*)>1)

[Explorerwen]

select user from (select count(*) num ,user from table group by user) where num >2

[yesterday2000]

实在不行
select count(*) as xh,user into #a from tablenam group by user
select a.*
from tablename a,#a b
where a.user=b.user and b.xh>1

[loye]

OK了，谢谢各位