COALESCE
is used to return first non-null expression within the arguments. This function is used to return a non-null from more than one column in the arguments. COALESCE
accepts all the values but it only returns non-null value present in the expression.COALESCE(expr1, expr2, expr3,......,expr n)