Returns the first non-NULL expression among its arguments, or NULL if all its arguments are NULL.
Syntax¶COALESCE( <expr1> , <expr2> [ , ... , <exprN> ] )
Copy
Usage notes¶If possible, pass in arguments of the same type. Avoid passing in arguments of different types.
If one of the arguments is a number, the function coerces non-numeric string arguments (for example, 'a string') and string arguments that aren’t constants to the type NUMBER(18,5).
For numeric string arguments that aren’t constants, if NUMBER(18,5) isn’t sufficient to represent the numeric value, then cast the argument to a type that can represent the value.
The collation specifications of all input arguments must be compatible.
The comparisons follow the collation based on the input arguments’ collations and precedences.
The collation of the result of the function is the highest-precedence collation of the inputs.
SELECT column1, column2, column3, coalesce(column1, column2, column3) FROM (values (1, 2, 3 ), (null, 2, 3 ), (null, null, 3 ), (null, null, null), (1, null, 3 ), (1, null, null), (1, 2, null) ) v; +---------+---------+---------+-------------------------------------+ | COLUMN1 | COLUMN2 | COLUMN3 | COALESCE(COLUMN1, COLUMN2, COLUMN3) | |---------+---------+---------+-------------------------------------| | 1 | 2 | 3 | 1 | | NULL | 2 | 3 | 2 | | NULL | NULL | 3 | 3 | | NULL | NULL | NULL | NULL | | 1 | NULL | 3 | 1 | | 1 | NULL | NULL | 1 | | 1 | 2 | NULL | 1 | +---------+---------+---------+-------------------------------------+
Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4