ANY/ALL/SOME Predicate Examples | Teradata Vantage - Example: ANY Quantifier - Advanced SQL Engine

ANY/ALL/SOME Predicate Examples | Teradata Vantage - Example: ANY Quantifier - Advanced SQL Engine - Teradata Database

SQL Functions, Expressions, and Predicates

Product

Advanced SQL Engine

Teradata Database

Release Number

17.05

17.00

Published

June 2020

Language

English (United States)

Last Update

2021-01-30

dita:mapPath

tpt1555966086716.ditamap

dita:ditavalPath

lze1555437562152.ditaval

dita:id

B035-1145

lifecycle

Product Category

Teradata Vantage™

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

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