17.10 - Equivalences Using ANY/ALL/SOME and Comparison Operators - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)

The following table provides equivalences for the ANY/ALL/SOME quantifiers, where op is a comparison operator.

This … Is equivalent to …
x op ALL (:a, :b, :c) (x op :a) AND (x op :b) AND (x op :c)
x op ANY (:a, :b, :c) (x op :a) OR (x op :b) OR (x op :c)
x op SOME (:a, :b, :c)

Here are some examples.

This expression … Is equivalent to …
x < ALL (:a, :b, :c) (x < :a) AND (x < :b) AND (x < :c)
x > ANY (:a, :b, :c) (x > :a) OR (x > :b) OR (x > :c)
x > SOME (:a, :b, :c)