MOD function
The MOD numeric function returns the remainder when dividing two numbers.
Syntax
MOD returns the remainder when the first parameter is divided by the second parameter. The result is negative only if the first parameter is negative. Parameters must be integers. The function returns an integer. If any parameter is NULL, the result is NULL.
For example:
MOD(7, 3)
returns 1
MOD(-7, 3)
returns -1
MOD(7, -3)
returns 1
MOD(6, 3)
returns 0