Aggregate function. Mod stands for Modulo. Calculates the remainder of a number divided by another number.

Syntax

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.

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

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

The following query returns NULL as the divisor is 0.

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

Was this Article Helpful?

Thanks For Your Feedback!