查找重复的电子邮箱
select Email from person
group by Email
having count(Email)>1;
超过5名学生的课
select class from courses
group by class having count(distinct student)>=5;
#distinct表中student去重后的数目
查找重复的电子邮箱
select Email from person
group by Email
having count(Email)>1;
超过5名学生的课
select class from courses
group by class having count(distinct student)>=5;
#distinct表中student去重后的数目