集合操作
- 交集
(select course_id from section where year = 2009)
intersect
(select course_id from section where year = 2010)
- 并集
(select course_id from section where year = 2009)
union
(select course_id from section where year = 2010)
- 差集
(select course_id from section where year = 2009)
except
(select course_id from section where year = 2010)
Null Values
Example:
select name
from instructor
where salary is null