Answer the question
In order to leave comments, you need to log in
Normal example ALL?
Hello everyone!)
I'm not quite aware of the ALL operator. Here's an example :
SELECT
first_name, last_name, salary
FROM
employees
WHERE
salary > ALL (SELECT
salary
FROM
employees
WHERE
department_id = 2)
SELECT
first_name, last_name, salary
FROM
employees
WHERE
salary > (SELECT
MAX(salary)
FROM
employees
WHERE
department_id = 2)
= ALL(subquery)
. Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question