17.10 - SQL Operators - Advanced SQL Engine - Teradata Database

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

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
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.