Course
Simulator
More
Premium
Log in
SQL Function Reference
Functions
COALESCE
COALESCE
Returns the first non-null element of the list
MySQL
COALESCE
(
val1
[
,
val2
,
.
.
.
.
,
val_n
]
)
Examples
MySQL
SELECT
COALESCE
(
NULL
,
NULL
,
1
,
2
)
;