16.20 - Example: ANY Quantifier - Advanced SQL Engine

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

Published

March 2019

Language

English (United States)

Last Update

2020-03-25

dita:mapPath

xzf1512079057909.ditamap

dita:ditavalPath

TD_DBS_16_20_Update1.ditaval

dita:id

kby1472250656485

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