16.20 - Operators - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageâ„¢ SQL Fundamentals

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
zce1519094756513.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

SQL operators express logical and arithmetic operations. Operators of the same precedence are evaluated from left to right.

Parentheses can be used to control the order of precedence. When parentheses are present, operations are performed from the innermost set of parentheses outward.

The following definitions apply to SQL operators.

Term Definition
numeric Any literal, data reference, or expression having a numeric value.
string Any character string or string expression.
logical A Boolean expression (resolves to TRUE, FALSE, or unknown).
value Any numeric, character, or byte data item.
set A collection of values returned by a subquery, or a list of values separated by commas and enclosed by parentheses.

SQL Operations and Precedence

SQL operations, and the order in which they are performed when no parentheses are present, appear in the following table. Operators of the same precedence are evaluated from left to right.

Precedence Result Type Operation
highest numeric + numeric   (unary plus)

- numeric    (unary minus)

intermediate numeric numeric ** numeric     (exponentiation)
numeric numeric * numeric     (multiplication)

numeric / numeric     (division)

numeric MOD numeric     (modulo operator)

numeric numeric + numeric    (addition)

numeric - numeric    (subtraction)

string concatenation operator
logical
  • value EQ value
  • value NE value
  • value GT value
  • value LE value
  • value LT value
  • value GE value
  • value IN set
  • value NOT IN set
  • value BETWEEN value AND value
  • character value LIKE character value
logical NOT logical
logical logical AND logical
lowest logical logical OR logical