coalesce function

COALESCE Definition & Meaning coalesce Usage · coalesce expression simplifies standard SQL expressions by allowing you to express a search condition as a simple comparison instead of using a when 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 Coalesce coalesce looks at the values in a list , and returns the first non-null value This function is useful when you want to: fill in missing