MODULO()

All functions > MATH > MODULO()

Returns the remainder after dividing the first number by the second.

Signatures

Modulo

Returns: Remainder of the division

MODULO(dividend: T, divisor: T) → T

With:

• T : Custom types: TINYINT | SMALLINT | INT | BIGINT | DECIMAL

Signature notes:

• Both arguments must be of the same type (integer or DECIMAL)
• Sign of the result matches the sign of the dividend
• Returns NULL if either operand is NULL
• Division by zero raises an error

Aliases

• MOD

Related operators

• % [remainder]

Examples

MODULO(...)

SELECT
    f1 := MODULO(10, 3) -- Function call
;

.MODULO(...) — chained

SELECT
    f1 := (10).MODULO(3), -- Integer literal: parenthesize for `.MODULO` on BIGINT
    f2 := 10.0.MODULO(3) -- Decimal base: chain without extra parentheses
;

Edge cases

SELECT
    f1 := MODULO(15, 4), -- Another remainder
    f2 := MODULO(7, 7), -- No remainder
    f3 := MODULO(-10, 3) -- Negative dividend
;