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

6 votes606 views3 answers
Sql select last id
SQL
0 vote246 views1 answer
Mysql relationships between tables
SQL
2 votes224 views2 answers
Postgres select duplicate columns
SQL
0 vote207 views1 answer
Cara menampilkan user di mysql terminal
SQL
2 votes244 views2 answers
How to run postgresql in linux
SQL
0 vote235 views3 answers
Duplicate row mysql
SQL
2 votes227 views1 answer
Sql update from different table
SQL
0 vote219 views1 answer
Sql server isnull function nor working count
SQL
0 vote246 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote217 views1 answer
Mysql select where field like in list
SQL