Table 22–2 lists the query language operators in order of decreasing precedence.
Table 22–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 |