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

Language

English (United States)

Last Update

2024-01-12

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