16.20 - Supported Comparison Operators - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

prodname
Advanced SQL Engine
Teradata Database
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1145-162K

Teradata Database supports the following comparison operators.

ANSI Operator Teradata Extensions Function
= EQ Tests for equality.
<> ^=
NE
NOT= Tests for inequality.
< LT Tests for less than.
<= LE Tests for less than or equal.
> GT Tests for greater than.
>= GE Tests for greater than or equal.