Question

In SQL, which function returns non-null values in a list?



Group of answer choices

CAST

COALESCE

DISTINCT

CONCAT

Answer 1

COALESCE — it returns the first non-NULL value from its argument list (e.g., COALESCE(a, b, 'default')).