Operator Precedence
The following table list operators from the highest precedence to lowest.
| precedence | operators | associativity |
|---|---|---|
| 1 | + (unary plus) | Right-to-left |
| - (unary minus) | Right-to-left | |
| ! | Right-to-left | |
| 2 | * | Left-to-right |
| / | Left-to-right | |
| % | Left-to-right | |
| 3 | + | Left-to-right |
| - | Left-to-right | |
| 4 | || | Left-to-right |
| 5 | = | nonassoc |
| == | nonassoc | |
| < | nonassoc | |
| <= | nonassoc | |
| > | nonassoc | |
| >= | nonassoc | |
| <> | nonassoc | |
| != | nonassoc | |
| IS | nonassoc | |
| BETWEEN | nonassoc | |
| IN | nonassoc | |
| LIKE | nonassoc | |
| 6 | NOT | Right-to-left |
| 7 | AND | Left-to-right |
| 8 | OR | Left-to-right |
| 9 | INTERSECT | Left-to-right |
| 10 | UNION | Left-to-right |
| EXCEPT | Left-to-right | |
| 11 | := | Right-to-left |