16.20 - Example: Using the ALL Quantifier to Compare Two Expressions - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

The following statement uses the ALL quantifier to compare two expressions with the values returned from a subquery to find the employee(s) with the most years of experience in the group of employees having the highest salary:

   SELECT EmpNo, Name, DeptNo, JobTitle, Salary, YrsExp
   FROM Employee 
   WHERE (Salary,YrsExp) >= ALL 
    (SELECT Salary,YrsExp FROM Employee) ;