MODULO

All functions > MATH > MODULO

Returns the remainder after dividing the first number by the second (modulo operation).

Syntax

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

Type Parameters:

• T: BIGINT or DECIMAL

Arguments

Returns

Same as input type - BIGINT or DECIMAL

Notes

• Returns the remainder of integer division
• Sign of result matches the sign of the dividend
• Returns NULL if either operand is NULL
• Operator form: dividend % divisor
• Division by zero results in an error
• Useful for cycling through values, checking even/odd, etc.

Aliases

• MOD

See also

• Operators

Examples