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 vote365 views1 answer
Login failed for user sql server
SQL
0 vote336 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote397 views1 answer
Connect google bigquery connect using sqirrel
SQL
2 votes393 views1 answer
Query to check cpu utilization in oracle database
SQL
3 votes304 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
1 vote338 views1 answer
Insert column after column mysql
SQL
4 votes338 views1 answer
Id primary key auto generated
SQL
2 votes347 views1 answer
Sql finding longest and shortest names in a fleld
SQL
1 vote344 views1 answer
Get table column names sql ssms
SQL
0 vote344 views2 answers
Postgresql change user role grant
SQL