MOD
Calculates the remainder after dividing two values, <value_n> / <value_d>.
Syntax
MOD(<value_n>,<value_d>)
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<value_n> | The numerator of the division equation | INT, BIGINT |
<value_d> | The denominator of the division equation | INT, BIGINT |
Return Type
BIGINT if one of the inputs is BIGINT. INT, otherwise.
Example
The following example returns the remainder of 45 and 7:
SELECT
MOD(45, 7);
Returns: 3