MOD
The function MOD returns the remainder of the division from 2 integer values.
| SQL Syntax 1: |
MOD( dividend, divisor ) | |
| Dividend: |
Any INT expression. | |
| Divisor: |
Any INT expression. | |
| Escape Syntax: |
{fn MOD( dividend, divisor )} | |
| Return Type: |
INT | |
Examples:
SELECT MOD(20,3), {fn mod(15,3)}Returns:2, 0
see also:
SQL Numeric Functions