REMAINDER Function [Numeric]

Returns the remainder when one whole number is divided by another.

Syntax

REMAINDER ( dividend, divisor )

Parameter	Description
dividend	The dividend, or numerator of the division.
divisor	The divisor, or denominator of the division.

INTEGER

NUMERIC

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