Returns the remainder when one whole number is divided by another.
MOD( dividend, divisor )
dividend The dividend, or numerator of the division.
divisor The divisor, or denominator of the division.
Division involving a negative dividend gives a negative or zero result. The sign of the divisor has no effect.
SQL/2008 The MOD function is part of optional SQL/2008 language feature T441.
The following statement returns the value 2.
SELECT MOD( 5, 3 );