查询选了全部课程的学生姓名。
/*
用双NOT EXISTS实现全称量词
*/
SELECT Sname
FROM Student
WHERE NOT EXISTS
(
SELECT *
FROM Course
WHERE NOT EXISTS
(
SELECT *
FROM SC
WHERE Sno= Student.Sno
AND Cno= Course.Cno
)
);
查询选修了全部学分是4分的课程的男生姓名。
select sname
from student
where ssex=