#可能存在重复的学生记录 所以应对学生字段去重复
select class
from courses
group by class
having count(distinct student)>=5; #count(distinct *)语法不对
LeetCode-SQL-596. 超过5名学生的课-easy
最新推荐文章于 2024-09-14 21:52:32 发布
#可能存在重复的学生记录 所以应对学生字段去重复
select class
from courses
group by class
having count(distinct student)>=5; #count(distinct *)语法不对