思路分析:
本查询涉及Student和SC关系
在Student中依次取每个元组的Sno值,用此值去检查SC表
若SC中存在这样的元组,其Sno值等于此Student.Sno值,并且其Cno= ‘1’,则取此Student.Sname送入结果表
方法一:
SELECT sname
FROM student
WHERE sno IN
(SELECT sno
FROM sc
WHERE cno='1');
方法二:
SELECT sname
FROM student
WHERE EXISTS
(SELECT *
FROM sc
WHERE sno=student.sno AND cno='1');
方法三:
SELECT sname
FROM student,
(SELECT sno FROM sc WHERE cno='1')AS sc1
WHERE student.sno=sc1.sno;