搜索重复的字段?????SQL语句怎么写 select * from 表名 where count(user)>1 group by user 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from table where user in ( select max(user) from table where having count(*)>1) select * from table where user in ( select max(user) from table group by user having count(*)>1) select user from (select count(*) num ,user from table group by user) where num >2 实在不行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 求两条语句 谢谢 关于SQL的命令 问一个数据库连接成本的问题 事务--与书本上写的有出入 知道了服务器名,怎么得到数据库名? reporting services的钻取报表动态显示列的问题 【急】关于员工薪资管理系统的相关问题(数据库课设) UPDATE中如何使用存储过程,100分求教 请问用vb的ado的connection连到sql server 2000,sql server2000最大能同时接受多少个connection的连接? 在DELPHI上,用MSSQL存储过程建立BOM主从临时表 急关于视图百分相送 sql安装的问题.
where having count(*)>1)
group by user
having count(*)>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