Precedence
Previous  Next

Operator precedences are shown in the following list, from lowest precedence to the highest. Operators that are shown together on a line have the same precedence.

OR
AND
NOT
BETWEEN
=, >=, >, <=, <, <>, LIKE, IN
-, +
*, /, %

The precedence of operators determines the order of evaluation of terms in an expression. To override this order and group terms explicitly, use parentheses.
For example:

4+ 5*3
/* = 19 */

(4+5)*3
/* = 27 */