Operator Precedence Hierarchy

Operator Precedence Hierarchy

 

 

Precedence Level Operator Symbol     Operation
1                ()                  Parentheses or brackets
2                /,*                 Division and multiplication
3                +,−                 Addition and subtraction
4                ||                  Concatenation
5                =,<,>,<=,>=         Equality and inequality
                                     comparison
6               [NOT] LIKE, IS [NOT] Pattern, null, and set
                NULL, [NOT] IN       comparison
7               [NOT]                BETWEEN Range comparison
8               !=,<>                Not equal to
9               NOT                  NOT logical condition
10              AND                  AND logical condition
11              OR                   OR logical condition