16.20 - IN - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

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