coalesce sql
snippet in sql

sql coalesce

user7818


  SELECT 
  COALESCE(NULL, NULL, NULL, 'W3Schools.com', NULL, 'Example.com'); 

coalesce sql

user8488

Return the first non-null value in a list:

SELECT COALESCE(NULL, NULL, NULL, 'W3Schools.com', NULL, 'Example.com');

-- output: W3Schools.com