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