第3章(2)DataBase课件.pptVIP

An Introduction to Database System 带有ANY或ALL谓词的子查询（续） [例39]：用集函数实现[例39] SELECT Sname，Sage FROM Student WHERE Sage (SELECT MAX(Sage) FROM Student WHERE Sdept= IS ) AND Sdept IS ’; An Introduction to Database System 带有ANY或ALL谓词的子查询（续） [例40] 查询其他系中比信息系所有学生年龄都小的学生姓名及年龄。 方法一：用ALL谓词 SELECT Sname，Sage FROM Student WHERE Sage ALL (SELECT Sage FROM Student WHERE Sdept= IS ) AND Sdept IS ’; 查询结果为空表。 An Introduction to Database System 带有ANY或A