COALESCE function

doc/user/content/sql/functions/coalesce.md

123428 B

COALESCE returns the first non-NULL element provided.

Signatures

Parameter	Type	Description
val	Any	The values you want to check.

All elements of the parameters for coalesce must be of the same type; coalesce returns that type, or NULL.

mzsql

SELECT coalesce(NULL, 3, 2, 1) AS coalesce_res;

nofmt

 res
-----
   3