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

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

The following statement uses a comparison operator with the ANY quantifier to select the employee number, name, and department number of anyone in departments 100, 300, and 500:

This Expression … Is Equivalent to this expression…
SELECT EmpNo, Name, DeptNo

FROM Employee

WHERE DeptNo = ANY (100,300,500) ;

  • SELECT EmpNo, Name, DeptNo
  • FROM Employee
  • WHERE (DeptNo = 100)
  • OR (DeptNo = 300)
  • OR (DeptNo = 500) ;

and

SELECT EmpNo, Name, DeptNo

FROM Employee

WHERE DeptNo IN (100,300,500) ;