REMAINDER

Syntax

REMAINDER(num1, num2);

Overview

REMAINDER is a function that returns the remainder of num1 divided by num2.

MODuses FLOOR, and REMAINDERis similar except that it uses Bankers' Round method.

Arguments	Description.
num1, num2	num1 and num2 must be numeric types or types that can be converted to numeric types. num1 and num2 are converted to the type with the higher numeric precedence of the two types, and are returned as that type.

Example

SELECT REMAINDER(3,2);
 remainder 
-----------
        -1