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

1 vote257 views1 answer
STOP message of how many rows affected sql
SQL
0 vote227 views1 answer
Redudancy in SQL
SQL
0 vote224 views1 answer
Mysql count unique in group statement
SQL
0 vote234 views1 answer
Possgress drop if exists view
SQL
0 vote225 views1 answer
Call rest api from postgresql
SQL
0 vote196 views1 answer
Split a string with expression and get the last value of split sql
SQL
1 vote228 views1 answer
Tsql create unique index composite
SQL
0 vote233 views1 answer
How to add unique key constraint in mysql
SQL
0 vote236 views1 answer
Oracle query archive mode
SQL
0 vote213 views1 answer
Install mysql 8 linux
SQL