# Expression precedence

Precedence of operations from highest to lowest is as follows.

- `()`, `?`, constants (including sign), NULL, columnReference, scalarSubquery, CAST
- LENGTH, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, and other built-ins
- Unary `+` and `-`
- `*`, `/`, `||` (concatenation)
- Binary `+` and`-`
- Comparisons, quantified comparisons, EXISTS, IN, IS NULL, LIKE, BETWEEN, IS
- NOT
- AND
- OR

You can explicitly specify precedence by placing expressions within parentheses. An expression within parentheses is evaluated before any operations outside the parentheses are applied to it.

## Example

    (3+4)*9
    (age < 16 OR age > 65) AND employed = TRUE

Parent topic: SQL expressions
Related concepts
Dynamic parameters
Related reference
selectExpression
tableExpression
NEXT VALUE FOR expression
VALUES expression
Boolean expressions
CASE expression