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

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

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product

Advanced SQL Engine

Teradata Database

Release Number

17.10

Published

July 2021

Language

English (United States)

Last Update

2021-07-28

dita:mapPath

SQL_Functions__Expressions__and_Predicates.Upload_071421/djk1612415574830.ditamap

dita:ditavalPath

SQL_Functions__Expressions__and_Predicates.Upload_071421/wrg1590696035526.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) ;