select Sname from student
where Sno IN
(select Sno from SC
group by Sno //根据Sno分组,统计每个学生选修了几门课程。如果等于course的总数,就是我们要找的Sno
having count(*) = (select count(*) from course )) //统计course中共有几门课程
--用一个简单逻辑
SELECT SNo
FROM CourseSelection
GROUP BY SNo
HAVING COUNT(*) = (SELECT COUNT(*) FROM Course) -- 选课数 = 课程总数
sql实现查询学习了所有课程的学生信息
最新推荐文章于 2024-05-31 16:06:48 发布