16.20 - SQL Expressions - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

SQL expressions specify a value, allowing you to perform arithmetic and logical operations and to generate new values or Boolean results from literals and stored values. An expression can consist of any of the following things:

  • Column name
  • Literal (sometimes referred to as a constant)
  • Function
  • USING variable
  • Parameter
  • Parameter marker (question mark (?) placeholder)
  • Combination of column names, literals, and functions connected by operators