Mysql coalesce

Coalesce mysql

The COALESCE() function returns the first non-null value in a list.

Example : SELECT COALESCE(NULL, NULL, 'W3Schools.com', NULL, 'Example.com');

output : 'W3Schools.com'

-1

Similar codes

0 vote139 views1 answer
Add column in sql server ubuntu
SQL
0 vote166 views2 answers
Oracle ora-00054 how to unlock
SQL
1 vote145 views1 answer
Postgresql delete cascade
SQL
0 vote135 views1 answer
Postpresql relation not found
SQL
0 vote138 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote160 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote128 views1 answer
Oracle 11g forget password
SQL
0 vote98 views2 answers
Postgresql could not start server mac
SQL
10 votes124 views3 answers
Join multiple tables sql
SQL
1 vote149 views1 answer
Median mysql
SQL