-
SQL syntax question
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);
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|