SQL arithmetic operators

Arithmetic operators take two numeric values (either literals or variables) and perform a calculation that returns a single numeric value.

OperatorDescription
+Addition
-Subtraction
*Multiplication
/Division
%Modulo

+

The + operator adds two operands together and returns the sum.

SELECT 1 + 2
int64(1) + int64(2)
3

-

The - operator subtracts the right operand from the left operand and returns the difference.

SELECT 4 - 2
int64(4) - int64(2)
2

*

The * operator multiplies two operands together and returns the product.

SELECT 2 * 3
int64(2) * int64(3)
6

/

The / operator divides the left operand by the right operand and returns the quotient.

SELECT 6 / 3
int64(6) / int64(3)
2

%

The % (modulo) operator divides the left operand by the right operand and returns the remainder. If the left operand is not divisible by the right operand, it returns the left operand.

SELECT 8 % 3
Int64(8) % Int64(3)
2
SELECT 3 % 8
Int64(3) % Int64(8)
3

Was this page helpful?

Thank you for your feedback!