ANY Predicate
Last updated
Last updated
This is a work in progress, changes may be applied in the future.
In Teradata enables quantification in a comparison operation or IN/NOT IN predicate. The comparison of expression and at least one value in the set of values returned by subquery is true. Please review the following for more information.
Teradata syntax
Where quantifier:
Snowflake syntax
In subquery form, IN is equivalent to = ANY
and NOT IN is equivalent to <> ALL
. Review the following for more infromation.
To compare individual values:
To compare row constructors (parenthesized lists of values):
To compare a value to the values returned by a subquery:
Teradata
Snowflake
When there are other comparison operators, there equivalent translation is to add a subquery with the required logic.
Teradata
Snowflake
Teradata
Snowflake
Teradata
Snowflake
Teradata
Snowflake
No related EWIs.