关于选了5门不同的课程:
考虑的因素:1、缩小范围 (缩小范围的办法有 特殊关联查询 1、在select 后 2.在from 后)
select s.stuName from student s ,(select cs2.stuId,cs2.courseId from core cs2 group by cs2.courseId,cs2.stuId ) a
where s.stuId = a.stuId having count(s.stuId)>=5;关于选了5门不同的课程:
考虑的因素:1、缩小范围 (缩小范围的办法有 特殊关联查询 1、在select 后 2.在from 后)
select s.stuName from student s ,(select cs2.stuId,cs2.courseId from core cs2 group by cs2.courseId,cs2.stuId ) a
where s.stuId = a.stuId having count(s.stuId)>=5;