15.00 - SQL Operators - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1145-015K
Language
English (United States)
Last Update
2018-09-24

SQL Operators

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

Types of Operators

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 operator, see Chapter 10: “Comparison Operators and Functions.”
  • Because comparison operators are a type of logical predicate, see Chapter 20: “Logical Predicates.” 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.