示例4：not in子查询.sql

来自「SQL Server数据库设计和高级查询[SQL Advance]」· SQL 代码 · 共 14 行

SELECT * FROM stuInfo
SELECT * FROM stumarks

/*--采用IN子查询，查看参加考试的学员名单--*/
SELECT stuName FROM stuInfo
  WHERE stuNo IN (SELECT stuNo FROM stuMarks)
GO

/*--采用NOT IN子查询，查看未参加考试的学员名单--*/
SELECT stuName FROM stuInfo
  WHERE stuNo NOT IN (SELECT stuNo FROM stuMarks)
GO