IN子查询
–使用IN后面的子查询可以返回多条记录。常用IN替换等于(=)的比较子查询
NOT IN子查询
--使用IN后面的子查询可以返回多条记录。常用IN替换等于(=)的比较子查询
Select StudentName from Students where StudentId IN
(Select StudentId from ScoreList where SQLServerDB>80)
--查询没有参加考试的学员、姓名?
Select StudentName from Students where studentId not in
(Select StudentId from ScoreList where SQLServerDB>80)