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 vote202 views1 answer
Oracle list constraints
SQL
10 votes218 views2 answers
Rtrim sql
SQL
1 vote189 views1 answer
Foreign key constraint in ms sql
SQL
11 votes204 views1 answer
Get ddl materialized view oracle
SQL
1 vote198 views1 answer
Woocommerce mysql price table
SQL
16 votes202 views1 answer
Mysql reset auto increment value
SQL
0 vote212 views1 answer
Where in clause tsql
SQL
1 vote193 views1 answer
Importance of comment in mysql
SQL
0 vote213 views1 answer
Reset keys in sql
SQL
0 vote206 views1 answer
Oracle merge insert if not exists
SQL