Operators are used in queries and subqueries to combine or test data for various properties, attributes, or relationships.
The available operators are described in the topics that follow, grouped into the following categories:
As an operator in a condition test, IN tests a scalar or row value for membership in a list of values, a relational expression, or a subquery.
--- IF column IN ('A','B','C') --- IF (col1, col2) IN ( select a, b from my_table )
Returns TRUE if the value being tested is found in the list, in the result of evaluating the relational expression, or in the rows returned by the subquery; returns FALSE otherwise.
Tests whether a relational expression returns any rows; returns TRUE if any row is returned, FALSE otherwise.
The two general classes of scalar operators are:
operand1 operator operand2
A few operators that use a different format are noted specifically in the operand descriptions below.
If an operator is given a null operand, the result is almost always null (see the topic on logical operators for exceptions).
Streaming SQL follows the usual precedence of operators:
Each of these operators works according to normal arithmetic behavior, with the following caveats:
|1 + 1||2|
|2.0 + 2.0||4.0|
|3.0 + 2||5.0|
|5 / 2||2|
|5.0 / 2||2.500000000000|