The available operators are described in the topics that follow, grouped into the following categories:
Operators are used in queries and subqueries to combine or test data for various properties, attributes, or relationships.
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|