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.