Comparison Operator Example | Teradata Vantage - 17.10 - 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
July 2021
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) ;