16.20 - Example: ALL Quantifier - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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