MOD(dividend, divisor).
MOD(dividend, divisor)
mssql has no MOD() function at all -- only the % operator, so mssql renders (dividend % divisor). ClickHouse's function is named modulo (not mod). Every other dialect here has a native MOD(a, b) function.
MOD()
%
(dividend % divisor)
modulo
mod
MOD(a, b)
MOD(dividend, divisor).mssql has no
MOD()function at all -- only the%operator, so mssql renders(dividend % divisor). ClickHouse's function is namedmodulo(notmod). Every other dialect here has a nativeMOD(a, b)function.