数据库06.pptVIP

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 10.1 SELECT高级查询 例：查询操作系统的任课老师 SELECT tname FROM teacher WHERE tno=(SELECT tno FROM course WHERE cname=‘操作系统’) SELECT teacher.tname FROM teacher JOIN course ON teacher.tno=course.tno WHERE cname=‘操作系统’ 返回一个值的子查询 10.1 SELECT高级查询 例：列出成绩表中,选修过学号的学生所选课程的所有成绩 SELECT * FROM 成绩表 WHERE 课程编号 IN (SELECT 课程编号 FROM 成绩表 WHERE 学号= ) 返回多个值的子查询 10.1 SELECT高级查询 例：查询最高分的学生姓名 SELECT sname FROM student WHERE sno=