◆◆寻求SQL语句，如何找出全校重名者的名单◆◆

[whjpn]

某学校DB，所有学生统一编号，编号为键值。学生姓名当然不能为键值。
重名的情况当然会有很多。
现在的问题是，如何找出这些重名者的名单？
用一条SQL语句实现。

(假设编号字段名为CODE，姓名字段名为NAME)

[zqfleaf]

select * from table
where Name in (select Name from table
group by name having count(*) > 1)

[didishu0807]

select code,name from table where name in (select name from table group by name having count(*) > 1)

[饮水需思源]

select name from tablename group by name having count(name)>1

[射天狼]

同意楼上几位!

[mymoto]

哈哈，学习中

[schzh]

我觉得应该加distinct：
select distinct name from table
where Name in (select Name from table
group by name having count(*) > 1)