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 vote186 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote186 views1 answer
Alter table add check constraint oracle
SQL
0 vote178 views1 answer
Sql query interview questions githu
SQL
0 vote176 views1 answer
Cast for print sql
SQL
2 votes181 views2 answers
Postgres drop column if exists
SQL
0 vote194 views1 answer
Load data infile mariadb slow
SQL
9 votes202 views6 answers
Check constraint in sql
SQL
0 vote190 views1 answer
How to add unique key constraint in mysql
SQL
0 vote166 views1 answer
Hive batch drop table
SQL
5 votes188 views1 answer
Oracle ora-00054 resource busy
SQL