16.20 - ANSI Compliance - 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

The following comparison operators are ANSI SQL:2011 compliant.

  • =
  • >
  • <
  • <>
  • <=
  • >=

The following comparison operators are Teradata extensions to the ANSI SQL:2011 standard.Their use is deprecated.

  • EQ
  • ^=
  • NE
  • NOT=
  • LT
  • LE
  • GT
  • GE