Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

coalesce sql

Return the first non-null value in a list:

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

-- output: W3Schools.com
 
PREVIOUS NEXT
Tagged: #coalesce #sql
ADD COMMENT
Topic
Name
4+4 =