Logical Operator Syntax | Teradata Vantage - 17.10 - Logical Operators - Advanced SQL Engine - Teradata Database

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

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

An operator applied to the result of a predicate to determine the result of a search condition.

The logical operators are:

  • AND
  • NOT
  • OR

For example:

expression_1 OR expression_2 OR expression_3

Use NOT to negate an expression, for example:

expression_1 AND NOT expression_2