sql查询同表查询 我有一张user表id name其中name中可以有相同名称的如:张三,张三我要把name相同值的数据查询出来sql怎么写? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select name from tb group by name having count(1)>1 select name from tb group by name having count(1) > 1select * from tb where name in (select name from tb group by name having count(1) > 1) select * from tb where name in(select name from tb group by name having count(1)>1) xiaoF 帮我的贴 移出非技术版吧 select [name],count(*) from [user]group by [name]having count(*)>1 SELECT * FROM TB T WHERE EXISTS(SELECT 1 FROM TB WHERE NAME=T.NAME AND ID<>T.ID) 我一移动 还真可以。。不小心点了基础班。下次去你的新技术板块 HOHO select name from tb group by name having count(1) > 1 select * from tb where name in (select name from tb group by name having count(1) > 1) 如何将sql server 2000表结构导出到另一机器的sql server 2000 高分请教多表查询的问题 求一sql语句,大家都进来看看 sql運算的難師,請幫忙 存储过程 (批量update) 哪个好? 无法解决 equal to 操作中 "SQL_Latin1_General_CP1_CI_AS" 和 "Chinese_PRC_CI_AS" 之间的排序规则冲突 如何同时得到SELECT执行的数据表和表的行数 sql2000数据库导入sql7.0中 SQL语句 在触发器中建表时,相用字符串变量作为表名怎么办? 插入类似于自增的列 sql 求名次 在线等人~~~~~
group by [name]
having count(*)>1
下次去你的新技术板块 HOHO
select name from tb group by name having count(1) > 1 select * from tb where name in (select name from tb group by name having count(1) > 1)