select class from courses
group by class having count(distinct student)>=5;
#distinct表中student去重后的数目
sql-超过5名学生的课
最新推荐文章于 2023-01-03 21:49:42 发布
select class from courses
group by class having count(distinct student)>=5;
#distinct表中student去重后的数目