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 vote347 views1 answer
Psql list view rules
SQL
8 votes369 views2 answers
Oracle undo usage
SQL
1 vote356 views1 answer
Tsql create unique index composite
SQL
0 vote365 views1 answer
SAP Return
SQL
2 votes316 views1 answer
Latest record in sql
SQL
0 vote304 views1 answer
'0000-00-00' for column '
SQL
0 vote360 views1 answer
Psql attribute cannot login
SQL
0 vote399 views1 answer
Psql create usr
SQL
0 vote375 views1 answer
Sql pivot table
SQL
5 votes375 views1 answer
Oracle list days between two dates
SQL