Which query finds employees who earn more than any manager ?

Question

Which query finds employees who earn more than  any manager ?

Accepted Answer

SELECT * FROM STAFF  WHERE Salary > ANY (SELECT Salary FROM STAFF WHERE JOB = 'MGR');

Answer

SELECT * FROM STAFF  WHERE Salary > (SELECT ANY(Salary) FROM STAFF WHERE JOB = 'MGR');

Answer

SELECT * FROM STAFF  WHERE Salary < ANY (SELECT Salary FROM STAFF WHERE JOB = 'MGR');

Answer

SELECT * FROM STAFF  WHERE Salary > ALL (SELECT Salary FROM STAFF WHERE JOB = 'MGR');

Crowdly