NumbersSQL standard

MOD

Returns the remainder of dividing one number by another.

Syntax

MOD(<dividend>, <divisor>)
<dividend> % <divisor>

MOD(10, 3) gives 1, because 10 = 3 · 3 + 1. The % operator does the same. Most often it's used to check whether a number is even, take every second row or deal rows into several groups in turn.

Data for the examples

orders

id	created_at	amount
1	2026-07-03 10:15:00	120.50
2	2026-07-28 18:40:00	80.25
3	2026-08-09 09:05:00	199.99
4	2026-08-21 14:30:00	45.00
5	2026-09-02 11:00:00	64.75

These tables already exist in the sandbox — the examples below use them. Want to try this in your own database? Copy the SQL.

The remainder of a division

SELECT MOD(10, 3) AS remainder,

10 % 3 AS with_operator;

remainder	with_operator
1	1

Even order numbers

SELECT id,

MOD(id, 2) = 0 AS is_even

FROM orders;

id	is_even
1	false
2	true
3	false
4	true
5	false

Every second order

SELECT id, amount

FROM orders

WHERE MOD(id, 2) = 0;

id	amount
2	80.25
4	45.00

Watch out

For a negative dividend, the remainder is negative too: MOD(-7, 3) gives -1, not 2. If you always need a non-negative one, use MOD(MOD(-7, 3) + 3, 3).

Division by zero is an error: MOD(5, 0) says division by zero.

It works for fractional numbers too: MOD(7.5, 2) gives 1.5.

Related functions

ABS FLOOR NTILE