SQL REMAINDER() Function

SQL REMAINDER() Function return the remainder value of n1 divide by n2. Where n1 and n2 is natural value.

SQL REMAINDER() Function explicitly uses ROUND() function to finding remainder formula.

  r = remainder
        n = number
        d = divisor

        r = n - (d * (n / d)) 
        WHERE  (n / d) = (37 / 5) = 7
               (d * 7) = 5 * 7 = 35
               n - (35) = 37 - 35 = 2

Supported Oracle SQL Version

  • Oracle 10g
  • Oracle 11g
  • Oracle 12c
  • Oracle 18c

Syntax

REMAINDER(n1,n2)

Example

Considering following example 4 raised to a 2 return the 16.

SQL> SELECT REMAINDER(37,5) "REMAINDER" FROM DUAL;

 REMAINDER
----------
         2

SQL> SELECT REMAINDER(29,5) "REMAINDER" FROM DUAL;

 REMAINDER
----------
        -1

SQL> SELECT REMAINDER(28,5) "REMAINDER" FROM DUAL;

 REMAINDER
----------
        -2

SQL> SELECT REMAINDER(27,5) "REMAINDER" FROM DUAL;

 REMAINDER
----------
         2