The MOD numeric function returns the remainder when dividing two numbers.
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.
MOD(7, 3)returns 1
MOD(-7, 3)returns -1
MOD(7, -3)returns 1
MOD(6, 3)returns 0