查询重复记录数

select count(num), max(name) from student --查找表中num列重复的，列出重复的记录数，并列出他的name属性

group by num

having count(num) >1 --按num分组后找出表中num列重复，即出现次数大于一次