SQL Operators - Advanced SQL Engine - Teradata Database

SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/djk1612415574830.ditamap
dita:ditavalPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/wrg1590696035526.ditaval
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata Vantageā„¢

SQL operators are symbols and keywords that perform operations on their arguments.

The following types of operators are available in SQL:

  • Arithmetic operators such as + and - operate on numeric, DateTime, and Interval data types.
  • The concatenation operator || operates on character and byte types.
  • Comparison operators such as = and > test the truth of relations between their arguments. For information on comparison operators, see Comparison Operators and Functions.

    Comparison operators are also known as conditional expressions because they result in a value of TRUE, FALSE, or unknown (NULL).

  • Set operators, or relational operators, such as INTERSECT and UNION combine result sets from multiple sources into a single result set.