Using the ANY Operator in Multiple-Row Subqueries
The ANY operator (and its synonym, the SOME operator) compares a value to each value returned by a subquery.
< ANY means less than the maximum.
> ANY means more than the minimum.
= ANY is equivalent to IN
Using the ALL Operator in Multiple-Row Subqueries
The ALL operator compares a value to every value returned by a subquery.
> ALL means more than the maximum and
< ALL means less than the minimum.
The NOT operator can be used with IN, ANY, and ALL operators.