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

Syntax

REMAINDER( dividend, divisor )

Parameters

Returns

INTEGER

NUMERIC

Remarks

Alternatively, try using the MOD function.

See also

• MOD function [Numeric]

Standards and compatibility

Example

The following statement returns the value 2.

SELECT REMAINDER( 5, 3 );