ALL Operator: Value is compared to every value returned by the subquery using the ALL operator.
> ALL denotes greater than the maximum
< ALL denotes less than the minimum
<> ALL is the same as NOT IN condition
ANY Operator: Value is compared to each value returned by the subquery using the ANY operator. SOME is a synonym for ANY operator.
> ANY denotes something more than the bare minimum
< ANY denotes a value lower than the maximum
= ANY is the same as the IN operator