CareerCup

SELECT empno, sal
FROM emp
WHERE sal > ANY (2000, 3000, 4000);

EMPNO SAL
---------- ----------
7566 2975
7698 2850
7782 2450
7788 3000
7839 5000
7902 3000

SQL>

-- Transformed to equivalent statement without ANY.

SELECT empno, sal
FROM emp
WHERE sal > 2000 OR sal > 3000 OR sal > 4000;

EMPNO SAL
---------- ----------
7566 2975
7698 2850
7782 2450
7788 3000
7839 5000
7902 3000

SELECT empno, sal
FROM emp
WHERE sal > ALL (2000, 3000, 4000);

EMPNO SAL
---------- ----------
7839 5000

SQL>

-- Transformed to equivalent statement without ALL.

SELECT empno, sal
FROM emp
WHERE sal > 2000 AND sal > 3000 AND sal > 4000;

EMPNO SAL
---------- ----------
7839 5000

SQL>

SELECT *

FROM EMPLOYEES

WHERE SALARY IN (1500, 3000, 2500)


In the query above, Oracle would select only those records where the salary is equal to either 1500, or 3000, or 2500.

ANY (or its synonym SOME) is a syntax sugar for EXISTS with a simple correlation:

SELECT *
FROM mytable
WHERE x <= ANY
(
SELECT y
FROM othertable
)

is the same as:

SELECT *
FROM mytable m
WHERE EXISTS
(
SELECT NULL
FROM othertable o
WHERE m.x <= o.y
)

With the equality condition on a not-nullable field, it becomes similar to IN.

All major databases, including SQL Server, MySQL and PostgreSQL, support this keyword.

Source: stackOverFlow