Skip to main content
Calculates the remainder after dividing two values, <value_n> / <value_d>.

Syntax

MOD(<value_n>,<value_d>)

Parameters

ParameterDescriptionSupported input types
<value_n>The numerator of the division equationINT, BIGINT, NUMERIC
<value_d>The denominator of the division equationINT, BIGINT, NUMERIC

Return Type

Same as the input.

Example

The following example returns the remainder of 45 divided by 7: