SQL · Numeric functions

mod()

The remainder of a division. SQLite uses the % operator.

sqlRunnable example sql course

Syntax

mod(a, b)

Example

Open in the lab

SELECT 17 % 5 AS remainder;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.