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/2003 SQL foundation feature outside of core SQL.
The following statement returns the value 2.
SELECT MOD( 5, 3 );