ANY/ALL/SOME Predicate Examples | Teradata Vantage - Example: ANY Quantifier - Analytics Database

ANY/ALL/SOME Predicate Examples | Teradata Vantage - Example: ANY Quantifier - Analytics Database - Teradata Vantage

SQL Functions, Expressions, and Predicates

Deployment

VantageCloud

VantageCore

Edition

Enterprise

IntelliFlex

VMware

Product

Analytics Database

Teradata Vantage

Release Number

17.20

Published

June 2022

ft:locale

en-US

ft:lastEdition

2025-03-30

dita:mapPath

obm1628111499646.ditamap

dita:ditavalPath

qkf1628213546010.ditaval

dita:id

kby1472250656485

lifecycle

latest

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