SQL FunctionsNumeric FunctionsMODULOOn this pageMODULOReturns the remainder of x divided by y. If y is 0, it returns an error.SyntaxMODULO( <x>, <y> )AliasesMODExamplesSELECT MOD(9, 2), MODULO(9, 2);┌──────────────────────────┐│ mod(9, 2) │ modulo(9, 2) │├───────────┼──────────────┤│ 1 │ 1 │└──────────────────────────┘