Outdated Version
You are viewing an older version of this section. View current production version.
MOD
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)
