Skip to main content
Version: 2.5

coalesce

Description

Returns the first non-NULL expression among the input parameters. Returns NULL if non-NULL expressions cannot be found.

Syntax

coalesce(expr1,...);

Parameters

expr1: the input expressions, which must evaluate to compatible data types. The supported data types are BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, DATETIME, DATE, DECIMALV2, DECIMAL32, DECIMAL64, DECIMAL128, VARCHAR, BITMAP, PERCENTILE, HLL, and TIME.

Return value

The return value has the same type as expr1.

Examples

mysql> select coalesce(3,NULL,1,1);
+-------------------------+
| coalesce(3, NULL, 1, 1) |
+-------------------------+
| 3 |
+-------------------------+
1 row in set (0.00 sec)