Subquery Types

Subqueries can be specified in many places:

• With aliases
• With IN or NOT IN
• In UPDATE, DELETE, and INSERT statements
• With comparison operators
• With ANY, SOME, or ALL
• With EXISTS or NOT EXISTS
• In place of an expression