Was this helpful?
Arithmetic Operators
Arithmetic operators are used to combine numeric expressions arithmetically to form other numeric expressions. Valid OpenSQL arithmetic operators are (in descending order of precedence):
Arithmetic Operator
Description
+ and -
plus, minus (unary)
* and /
multiplication, division (binary)
+ and -
addition, subtraction (binary)
Unary operators group from right to left and binary operators group from left to right. The unary minus (-) can be used to reverse the algebraic sign of a value.
Use parentheses to force the desired order of precedence. For example:
(job.lowsal + 1000) * 12
is an expression in which the parentheses force the addition operator (+) to take precedence over the multiplication operator (*).
Last modified date: 01/30/2023