How do i coalesce?

1

Is there an equivelant function to coalesce?

So if I have a dataset and I want a single column to return the first non null value from a set:

select coalesce(a.val1, b.val2) from dataset
2

Apparently you just read the docs: https://docs.dremio.com/sql-reference/sql-functions/conditional.html#coalesce

2 Likes