All - Operator
SELECT empno, sal
FROM emp
WHERE sal > ALL (1999, 2999, 3999);
Output of Above query is same as below query
SELECT empno, sal
FROM emp
WHERE sal > 1999 AND sal > 2999 AND sal > 3999;
ANY Operator:
SELECT empno, sal
FROM emp
WHERE sal > ANY (1999, 2999, 3999);
Output of Above query is same as below query
SELECT empno, sal
FROM emp
WHERE sal > 1999 OR sal > 2999 OR sal > 3999;