# MOD

`MOD` stands for Modulo. The `MOD()` function calculates the remainder of a number divided by another number.

## Syntax

```sql
MOD (expression1 , expression2)
expression1 MOD expression2
expression1 `%` expression2

```

## Arguments

* `expression1`, `expression2` : Any numerical expression. This could be a column name, the result of another function, or a math operation.
* `expression1`: dividend. A value that will be divided by `expression2`.
* `expression2`: divisor.

## Return Type

A decimal if the input is decimal, otherwise integer.

## Remarks

Returns `NULL` if the divisor is 0 or either of the arguments is a `NULL`.

## Examples

The following queries return the remainder.

```sql
SELECT MOD (84,5);

```

```output

+------------------------------+
| mod (84,5)                   |
+------------------------------+
| 4                            |
+------------------------------+
1 row in set (899 ms)

```

```sql
SELECT 12 MOD 5;

```

```output

+------------------------------+
| 12 MOD 5                     |
+------------------------------+
| 2                            |
+------------------------------+
1 row in set (346 ms)

```

The following query returns `NULL` as the divisor is 0.

```sql
SELECT 25 % 0;

```

```output

+------------------------------+
| 25 % 0                       |
+------------------------------+
| NULL                         |
+------------------------------+
1 row in set (341 ms)

```

***

Modified at: June 26, 2026

Source: [/cloud/reference/sql-reference/aggregate-functions/mod/](https://docs.singlestore.com/cloud/reference/sql-reference/aggregate-functions/mod/)

(An index of the documentation is available at /llms.txt)