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. |