Operator Description
**Exponentiation
+, -Identity, negation (unary operation)
*, /Multiplication, division
+, -, ||Addition, subtraction, concatenation
=, , =, , !=, ~= IS NULL, LIKE, BETWEEN, INComparison
NOTLogical negation
ANDConjunction
ORInclusion
Operations with higher precedence are applied first.
Operators with the same precedence are applied in their text order:
You can change the execution order by using parentheses.
If the expression includes parentheses, the execution starts with the innermost pair.