34,837
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
loye 2004-08-04
- 打赏
- 举报
OK了，谢谢各位
yesterday2000 2004-08-04
- 打赏
- 举报
实在不行
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
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
Explorerwen 2004-08-04
- 打赏
- 举报
select user from (select count(*) num ,user from table group by user) where num >2
yesterday2000 2004-08-04
- 打赏
- 举报
select * from table where user in (
select max(user) from table
group by user
having count(*)>1)
select max(user) from table
group by user
having count(*)>1)
loye 2004-08-04
- 打赏
- 举报
不行啊，我都试过了
yesterday2000 2004-08-04
- 打赏
- 举报
select * from table where user in (
select max(user) from table
where having count(*)>1)
select max(user) from table
where having count(*)>1)
dqjia 2004-08-04
- 打赏
- 举报
用count()函数
xinliangyu 2004-08-04
- 打赏
- 举报
select * from 表名 where count(user)>1 group by user
