MOD

Calculates the remainder after dividing two values, <value_n> / <value_d>.

Syntax

MOD(<value_n>,<value_d>)

Parameter	Description	Supported input types
`<value_n>`	The numerator of the division equation	`INT`, `BIGINT`, `NUMERIC`
`<value_d>`	The denominator of the division equation	`INT`, `BIGINT`, `NUMERIC`

Same as the input.

The following example returns the remainder of 45 divided by 7:

SELECT MOD(45, 7);

mod int
3

Rows: 1Execution time: 5.35ms

⌘I