| 1. 2. 1. The normal rules of arithmetic operator precedence apply in SQL |
|
|
The normal rules of arithmetic operator precedence apply in SQL: |
multiplication and division are performed first. |
followed by addition and subtraction. |
If operators of the same precedence are used, they are performed from left to right. |
|
SQL> SELECT 10 * 12 / 3 - 1 FROM dual;
10*12/3-1
----------
39
SQL>
|
|