Oracle Glossary :ANY

The ANY comparison condition is used to compare a value to a list or
subquery. It must be preceded by =, !=, >, <, <=, >= and followed by a list
or subquery.
When the ANY condition is followed by a list, the optimizer expands
the initial condition to all elements of the list and strings them together
with OR operators, as shown below.
SELECT … fields …
FROM   … table …
WHERE  sal > ANY (2000, 3000, 4000);
note: The SOME and ANY comparison conditions do exactly the same
thing and are completely interchangeable.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *