Returns the remainder when one whole number is divided by another.
REMAINDER ( dividend, divisor )
Parameter
Description
dividend
The dividend, or numerator of the division.
divisor
The divisor, or denominator of the division.
INTEGER
REMAINDER is the same as the MOD function.
SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Not supported in Adaptive Server Enterprise. The % (modulo) operator and the division operator can be used to produce a remainder.
The following statement returns the value 2:
SELECT REMAINDER( 5, 3 ) FROM iq_dummy