Subquery Types

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