Skip to main content

SingleStoreDB v8.1

COALESCE

Given a list of values, returns the first non-NULL value.

Syntax

COALESCE ( val, [val, [val ...]])

Arguments

  • val: any object

Return Type

Return the first non-NULL value in the list. Returns NULL if all values are NULL.

Examples

SELECT COALESCE(NULL, NULL, 1, 2, 3);
****
+-------------------------------+
| COALESCE(NULL, NULL, 1, 2, 3) |
+-------------------------------+
|                             1 |
+-------------------------------+
In this section: