16.20 - Example: ALL Quantifier - Advanced SQL Engine - Teradata Database

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) ;