SQL Operators | SQL Fundamentals | VantageCloud Lake - Operators - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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

The following table summarizes the SQL operations in order of precedence. Operators of the same precedence are evaluated from left to right. Parentheses can change the order of evaluation.

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