16.20 - SQL Expressions - Teradata Vantage NewSQL Engine

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

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

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