求SQL语句, 要求能把某一字段的值有重复的,查询出来! 来者有分 select name from student s1,student s2 where s1.name=s2.name 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Select name,count(*) as 重复次数 from 表 group by namehaving count(*) > 1 SELECT * FROM STUDENT WHERE NAME IN (SELECT NAME FROM STUDENT GROUP BY NAME HAVING COUNT(NAME)>1 ) select name from student group by name having count(name) > 1 select * from student a where (select sum(1) from student where name=a.name)>1 select name from student where name in (select name from student) 急,要条语句 怎样把两个select出的列合并 如何清理sqlserver ldf文件? 数据库性能 用excel表更新sql表怎样方便写?条件要对应多个列,更新也要更新三个列 sql-server打补丁时出错 有成功在WIN XP PRO上装上MS SQL server 2000的么? 如何在select 中使用chr(13)来使得导出的数据中有回车? 急!Windows 98 客户端如何查询SQL SERVER库 在VB中使用ADO DATA控件的一个问题 两个简单问题 菜鸟问题:如何控制存储过程的执行
group by name
having count(*) > 1
(SELECT NAME FROM STUDENT
GROUP BY NAME HAVING COUNT(NAME)>1
)