---
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-dedicated/reference/sql/operators/arithmetic/
estimated_tokens: 1519
product: InfluxDB Cloud Dedicated
version: cloud-dedicated
---

# SQL arithmetic operators

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

| Operator | Description |  |
| --- | --- | --- |
| + | Addition |  |
| - | Subtraction |  |
| * | Multiplication |  |
| / | Division |  |
| % | 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 |