The comparison operator ALL compares a single value to a set or multi-set (nested query).
SELECT name
FROM employee
WHERE salary > ALL(
SELECT salary
FROM employee
WHERE department_number=5
)The comparison operator ALL compares a single value to a set or multi-set (nested query).
SELECT name
FROM employee
WHERE salary > ALL(
SELECT salary
FROM employee
WHERE department_number=5
)