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
Returns expr2 if expr1 is NULL, or expr1 otherwise. This function is a synonym for coalesce(expr1, expr2) with two arguments.
Syntax
ifnull(expr1, expr2)
Arguments
expr1: An expression of any type.expr2: An expression sharing a least common type withexpr1.
Returns
The result type is the least common type of expr1 and expr2.
Examples
> SELECT ifnull(NULL, array('2'));
[2]