---
title: SQL arithmetic operators
description: Arithmetic operators take two numeric values (either literals or variables) and perform a calculation that returns a single numeric value.
url: https://docs.influxdata.com/influxdb3/cloud-serverless/reference/sql/operators/arithmetic/
estimated_tokens: 537
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb3/cloud-serverless/reference/sql/operators/arithmetic/
date: '2025-04-03T12:43:17-06:00'
lastmod: '2025-04-03T12:43:17-06:00'
---

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

|Operator| Description  |                   |
|--------|--------------|-------------------|
|  `+`   |   Addition   |   [](#addition)   |
|  `-`   | Subtraction  | [](#subtraction)  |
|  `*`   |Multiplication|[](#multiplication)|
|  `/`   |   Division   |   [](#division)   |
|  `%`   |    Modulo    |    [](#modulo)    |

## \+

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

```sql
SELECT 1 + 2
```

|int64(1) + int64(2)|
|-------------------|
|         3         |

## \-

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

```sql
SELECT 4 - 2
```

|int64(4) - int64(2)|
|-------------------|
|         2         |

## \*

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

```sql
SELECT 2 * 3
```

|int64(2) \* int64(3)|
|--------------------|
|         6          |

/
----------

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

```sql
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.

```sql
SELECT 8 % 3
```

|Int64(8) % Int64(3)|
|-------------------|
|         2         |

```sql
SELECT 3 % 8
```

|Int64(3) % Int64(8)|
|-------------------|
|         3         |
| Operator | Description |  |
| --- | --- | --- |
| Operator | Description |  |
| + | Addition |  |
| - | Subtraction |  |
| * | Multiplication |  |
| / | Division |  |
| % | Modulo |  |

| int64(1) + int64(2) |
| --- |
| int64(1) + int64(2) |
| 3 |

| int64(4) - int64(2) |
| --- |
| int64(4) - int64(2) |
| 2 |

| int64(2) * int64(3) |
| --- |
| int64(2) * int64(3) |
| 6 |

| int64(6) / int64(3) |
| --- |
| int64(6) / int64(3) |
| 2 |

| Int64(8) % Int64(3) |
| --- |
| Int64(8) % Int64(3) |
| 2 |

| Int64(3) % Int64(8) |
| --- |
| Int64(3) % Int64(8) |
| 3 |