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