COALESCE Function

Returns the value of the first non-null expression in the list If all expressions evaluate to null, then COALESCE returns null

Learn how to use the SQL expression COALESCE to get the value of the first non-null argument in a scalar expression, if any; otherwise NULL

coalesce Although COALESCE , GREATEST , and LEAST are syntactically similar to functions, they are not ordinary functions, and thus cannot be used with explicit VARIADIC

coalesce The coalesce function can be used to assign a target object a user-defined value or the result of an expression when null values are read · A maximum of ten