Example: ANY Quantifier

Teradata Vantage™ SQL Functions, Expressions, and Predicates

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

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