SQL MOD()

The SQL math function MOD() returns the remainder after dividing one number by another. This is commonly used to determine if a number is even or odd, or to cycle through values.

Note: The behavior of MOD() may vary slightly between SQL dialects. For example, some databases use % as an alternative operator.

Syntax

MOD(dividend, divisor)

Parameters:

• dividend: The number to be divided.
• divisor: The number by which to divide.

Return value:

Returns the remainder obtained after dividing dividend by divisor.

Example 1

This example uses the MOD() function to find the remainder of 10 divided by 3:

SELECT MOD(10, 3);

Copy to clipboard
Copy to clipboard

The output of this code is:

1

Copy to clipboard
Copy to clipboard

Example 2

Given a table numbers:

This query uses MOD() to check which values are even:

SELECT id, value, MOD(value, 2) AS remainder FROM numbers;

Copy to clipboard
Copy to clipboard

The output will be:

| id | value | remainder |
|----|-------|-----------|
| 1  | 7     | 1         |
| 2  | 12    | 0         |
| 3  | 15    | 1         |

Copy to clipboard
Copy to clipboard

Here, a remainder of 0 indicates an even number.