SQL MOD()函数
MOD(N,M)
此函数返回N除以M余值,请考虑以下的例子:
SQL>SELECT MOD(29,3); +---------------------------------------------------------+ | MOD(29,3) | +---------------------------------------------------------+ | 2 | +---------------------------------------------------------+ 1 row in set (0.00 sec)