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.