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

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
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)