CS 330
Lecture 7

SQL

Reading Textbook, Chapter 9.3 (Nested clauses).

Nested clauses.
IN, NOT IN, EXISTS, NOT EXISTS
Set comparison: =ANY, =ALL, > ANY, >ALL, etc.
Examples from the Sailors database.