chapter3 sql关系数据库标准语言.pptVIP

例： 查询选修了‘01’课程的学生信息 select * from xs where xh in ( select xh from xk where kh=‘01’); select xs.* from xs, xk where xs.xh=xk.xh and kh= ‘01’; select * from xs where exists ( select * from xk where xs.xh=xk.xh and kh=‘01’); xh 001 002 003 xh kh 001 01 001 02 001 03 002 02 002 03 003 01 003 02 √ ╳ √ 例： 查询未选修‘01’课程的学生信息 select * from xs where xh not in ( select xh from xk where kh=‘01’); select * from xs where exists ( select * from xk where xs.xh=xk.xh and