IN 子查询
- (NOT)IN子查询:表达式 【NOT】in (子查询)
例:列出张三、王三同学所有信息:
Select *
From Student
Where Sname in
(‘张三’,’王三‘);
列出选秀了001号课程学生的学号和姓名:
Select S#, Sname
From Student
Where S# in
(Select S# From SC Where C#=‘001’);
列出选秀了001号课程和002号课程的学生的学号:
Select S#
From SC
Where C#=‘001’ and
S# in (Select S# from SC where C#=‘002’);
列出没学过李明老师课程的所有同学姓名:
Select Sname
From Student
Where S# NOT in
(Select S#
From SC, Course C, Teacher T
Where T.tname=‘李明’ and SC.C#=C.C# and T.T#=C.T#);
-
以上例子均为非相关子查询
-
相关子查询: