查询出字段中重复数>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表
发表评论