Link Search Menu Expand Document

MOD

Calculates the remainder after dividing two values, <num> / <den>.

Syntax 

MOD(<num>,<den>)
Parameter Description
<num> The numerator of the division equation.
<den> The denominator of the division equation.

Example 

SELECT
    MOD(45, 7);

Returns: 3