Table 27–2 lists the query language operators in order of decreasing precedence.
Table 27–2 Query Language Order Precedence|
Type |
Precedence Order |
|---|---|
|
Navigation |
. (a period) |
|
Arithmetic |
+ – (unary) * / (multiplication and division) + – (addition and subtraction) |
|
Comparison |
= > >= < <= <> (not equal) [NOT] BETWEEN [NOT] LIKE [NOT] IN IS [NOT] NULL IS [NOT] EMPTY [NOT] MEMBER OF |
|
Logical |
NOT AND OR |