Skip to main content

COALESCE

Returns the first argument which is not NULL from a series of two or more arguments, can be used to substitute a default value for a NULL value.

The COALESCE function is equivalent to the NVL function in Oracle or the IFNULL function in MySQL.

See also:
[SELECT] [IFNULL] [NULLIF]


Syntax

SELECT COALESCE(expression1, expression2 [, ..]) FROM <multipartIdentifier>;

Arguments

expression
Two or more expressions of any data type which resolve to a NULL or non NULL value.

If all of the expression arguments are NULL, the COALESCE function returns NULL.

Return Value(s)

Returns the first non NULL value from the series of expression arguments.


Examples

Replace a NULL value with a default value

SELECT name, coalesce(website, cors, 'not hosting shared resources') AS website_or_cors_config
FROM google.storage.buckets where project = 'stackql';

For more information, see https://www.sqlite.org/lang_corefunc.html#coalesce