SQL Expressions

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

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
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