16.20 - Types of Logical Predicates - 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

SQL provides the following logical predicates:

  • Comparison operators
  • [NOT] BETWEEN
  • LIKE
  • [NOT] IN
  • [NOT] EXISTS
  • OVERLAPS
  • IS [NOT] NULL