Syntax : IN, NOT IN, ANY, SOME, and ALL Logical Predicates - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

where:

 

Syntax element …

Specifies …

expression

any valid SQL expression.

To specify multiple expressions, enclose them within PARENTHESIS characters and separate each expression with a COMMA character.

comparison_operator

any valid SQL comparison operator.

See SQL Functions, Operators, Expressions, and Predicates for information about the SQL comparison operators.

IN (in_list)

NOT IN (in_list)

that expression is either IN or NOT IN the parenthetically delimited list of values.

See SQL Functions, Operators, Expressions, and Predicates for information about the IN and NOT IN logical predicates and the valid expressions that you can specify in an in_list.

ANY

the ANY logical quantifier.

See SQL Functions, Operators, Expressions, and Predicates for more information about the ANY logical quantifier.

SOME

the SOME logical quantifier.

See SQL Functions, Operators, Expressions, and Predicates for more information about the SOME logical quantifier.

ALL

the ALL logical quantifier.

See SQL Functions, Operators, Expressions, and Predicates for more information about the ALL logical quantifier.

subquery

any valid SQL subquery.