SQL Nested Query

• ALL→ Must satisfy expression for all rows in the sub-query.
• ANY→ Must satisfy expression for at least one row in the sub-query.
• IN→ Equivalent to ‘=ANY()‘.
• EXISTS→ At least one row is returned without comparing it to an attribute in outer query.