ANY Operator compares value to each value returned by the subquery. ANY operator has a synonym SOME operator.
* > ANY means more than the minimum.
* < ANY means less than the maximum
* = ANY is equivalent to IN operator.
ALL Operator compares value to every value returned by the subquery.
* > ALL means more than the maximum
* < ALL means less than the minimum
* <> ALL is equivalent to NOT IN condition.