COALESCE
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
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.
Examples
SELECT COALESCE(NULL, NULL, 1, 2, 3);
+-------------------------------+
| COALESCE(NULL, NULL, 1, 2, 3) |
+-------------------------------+
| 1 |
+-------------------------------+
Last modified: February 24, 2023