Skip to content
v1.36.6
Install

SQL Reference

REMAINDER

REMAINDER(n1, n2)

Section titled “REMAINDER(n1, n2)”
  • n1: The dividend.
  • n2: The divisor. The result is n1 - n2 * N where N is the integer nearest n1 / n2.

Example

Section titled “Example”
SELECT REMAINDER(10, 3) FROM dual;

Output

Section titled “Output”
1

Explanation

Section titled “Explanation”

The REMAINDER function in Oracle is used to return the remainder of a division operation between two numbers. In this case, 3 divides into 10 three times with one left over. So the output of the function REMAINDER(10, 3) is 1.