Subquery Types

From Accessing and Changing Relational Data

previous page next page

Accessing and Changing Relational Data

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

previous page start next page