Operator Precedence
An expression is a combination of literal values, variables, operators and functions.
Precedence and associativity determine the evaluation order of the operators.
Operators with higher precedence are evaluated first.
The associativity determines the direction in which operators of the same precedence are evaluated.
Operator Precedence Table
| Precedence | Operator | Associativity |
|---|---|---|
| 1 | + (Unary plus), - (Unary minus), ~ (Unary Bitwise NOT) | Right-to-left |
| 2 | * (Multiply), / (Division), % (Modulo) | Left-to-right |
| 3 | + (Add, Concatenate), - (Subtract), & (Bitwise AND), ^ (Bitwise XOR), | (Bitwise OR) | Left-to-right |
| 4 | =, >, <, >=, <=, <>, !=, !>, !< (Comparison) | Left-to-right |
| 5 | IS NULL, LIKE, BETWEEN, IN, ALL, ANY, SOME | Left-to-right |
| 6 | NOT (Unary Logical Not) | Right-to-left |
| 7 | AND (Logical And) | Left-to-right |
| 8 | OR (Logical Or) | Left-to-right |