# 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