查询出字段中重复数>1的sql语句;查找出学生表中，重复的姓名及重复个数

select name,count(*) as num from students  group by name having num>1;

查询出重复学生姓名，学号,重复个数

select a.name,a.no,b.num from (select name,count(*) as num from students  group by name having num>1) as b left join students a on a.name=b.name

?

b是查询重复姓名及个数的结果集表，a是正常students表