Nóta
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as shíniú isteach nó eolairí a athrú.
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as eolairí a athrú.
Applies to: 
Databricks SQL Databricks Runtime 15.3 and above
Returns the remainder after dividend / divisor or NULL ifdivisor is 0.
Syntax
try_mod(dividend, divisor)
Arguments
dividend: An expression that evaluates to a numeric.divisor: An expression that evaluates to a numeric.
Returns
If both dividend and divisor are of DECIMAL, the result matches the divisor's type.
In all other cases, a DOUBLE.
If divisor is 0, the function returns NULL. To raise DIVIDE_BY_ZERO error instead use the mod() function.
Examples
> SELECT try_mod(2, 1.8);
0.2
> SELECT try_mod(2, 0);
NULL