The following operators are special characters common to SQL and most programming languages:
These binary operations are available:
+ Add (for compatibility with SQL string concatenation may also be defined using “||”)
- Subtract
* Multiply
/ Divide
These comparison operations are available:
= EqualTo (EQ)
<> NotEqualTo (NE)
> GreaterThan (GT)
>= GreaterThanOrEqualTo (GE)
< LessThan (LT)
<= LessThanOrEqualTo (LE)
The following precedence is shown from highest to lowest:
Negate NOT
Multiply Divide
Add Subtract
EQ NE GT GE LT LE
AND
OR