16.20 - IN - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

Specifies whether the test is inclusive or exclusive.

You can substitute:

  • IN ANY
  • IN SOME
  • = ANY
  • = SOME5

for IN, unless a list of literals is specified and includes signed_literal_1 TO signed_literal_2

You can substitute:

  • <> ALL
  • NOT IN ALL