ANY
The If any value from outcome of subquery is macthed then desired output will be retrived.It checks with lowest value .

ALL
Itwill check for greatest value from outcome of subquery

DEAR ALL

ANY or SOME : Compares a value to each value in a list or retuned by a query. Must be

preceded by ! > < < > Evalutes FALSE when query returns no rows.

select empno ename sal from emp where sal any(1500 3000);

EMPNO ENAME SAL

------- ---------- ----------

7499 ALLEN 1600

7566 JONES 2975

7839 KING 5000

7902 FORD 3000

so optimizer take above query as

--select empno ename sal from emp where sal>1500 or sal>3000;

ALL : Compares a value to every value in a list or return by a query .Must be preceded by

! > < > < . Evalutes to TRUE if the query returns no rows.

select empno ename sal from emp where sal > ALL (1600 3000);

EMPNO ENAME SAL

---------- ---------- ----------

7839 KING 5000

-- in other words optimizer take this query as

--select empno ename sal from emp where sal 1600 AND sal>3000;

Regards

Nikhil