What's the "= ANY" and "= SOME" syntax for? I can't see any difference from "= ANY" and using "IN".
SELECT * FROM employees
WHERE salary = ANY
(SELECT salary
FROM employees
WHERE department_id = 30);
This example from the Oracle docs really doesn't make sense to me either:
SELECT * FROM employees
WHERE salary >=
ALL ( 1400, 3000);