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