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 vote101 views1 answer
Mysql workbench indent formatting
SQL
0 vote117 views1 answer
Oracle synonym procedure dblink
SQL
57 votes269 views5 answers
How to create a new user in postgresql
SQL
3 votes109 views3 answers
Mysql order by list
SQL
0 vote120 views1 answer
Wordpress sql find and replace
SQL
0 vote115 views1 answer
Query only first letter string
SQL
0 vote121 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote209 views1 answer
Mysql edit trigger
SQL
0 vote120 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote118 views1 answer
Compress sql file database ubuntu
SQL