Checks from left to right for the first non-NULL argument found for each entry parameter pair.

​
Syntax

COALESCE(<expression> [,...])

​
Parameters

ParameterDescriptionSupported input types
<expression>The expression(s) to coalesce.Any

​
Return Types

Same as input type

​
Example

The following example returns the first non-NULL value provided, which is the username esimpson:

SELECT COALESCE(NULL, 'esimpson','sabrina21') AS nicknames;

Returns: esimpson