17.10 - SQL Operators - Advanced SQL Engine - Teradata Database

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)

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.