4. Understanding the Elements of SQL Statements : SQL Operators : Arithmetic Operators
 
Share this page                  
Arithmetic Operators
Arithmetic operators are used to combine numeric expressions arithmetically to form other numeric expressions.
The arithmetic operators (in order of precedence) are as follows:
Arithmetic Operator
Description
+ and –
Positive, negative (unary)
**
Exponentiation (binary)
* and /
Multiplication, division (binary)
+ and –
Addition, subtraction (binary)
Unary operators group from right to left, while binary operators group from left to right. Use the unary negative (-) to reverse the algebraic sign of a value.
To force a desired order of evaluation, use parentheses. For example:
(job.lowsal + 1000) * 12
is an expression in which the parentheses force the addition operator (+) to take precedence over the multiplication operator (*).