You are here

Operator Precedence

All operators are executed in a defined priority:

OperatorDecriptionPriority
+- sing 0
* / multiply, divide 1
+ - add, substact 2
= equal 3
<> not equal 3
> greater 3
< smaller 3
>= greater or equal 3
<= smaller or equal 3
[NOT] BETWEEN ...
AND ...
[not] between ... and 3
IS [NOT] NULL [not] NULL-value 3
[NOT] IN [not] in the list 3
NOT Negation 4
AND logical and 5
OR logical or 6