Here is an example that uses a subquery in a comparison operation that specifies the ALL quantifier:
SELECT EmpNo, Name, JobTitle, Salary, YrsExp FROM Employee WHERE (Salary, YrsExp) >= ALL (SELECT Salary, YrsExp FROM Employee) ;
Here is an example that uses a subquery in a comparison operation that specifies the ALL quantifier:
SELECT EmpNo, Name, JobTitle, Salary, YrsExp FROM Employee WHERE (Salary, YrsExp) >= ALL (SELECT Salary, YrsExp FROM Employee) ;