Skip to main content

MOD

Calculates the remainder of x divided by y, returning the modulus. This is similar to using the '%' operator but is compatible with non-integer arguments.

See also:
[SELECT]

Syntax​

SELECT MOD(x, y) FROM <multipartIdentifier>;

Arguments​

x
The dividend, which is a numeric expression.

y
The divisor, also a numeric expression.

Return Value(s)​

Returns the remainder of x divided by y.

Examples​

Calculate the modulus of 10 divided by 3​

SELECT MOD(10, 3) AS remainder;