SQL COALESCE Function and NULL - Essential SQL
Comparing SQL COALESCE to CASE. Did you know SQL COALESCE is a shortcut for the CASE statement? Consider the table survey, which has the columns answerID, option1, option2, option3. We want to list the answerID and first non NULL option. From what we have learned we can use COALESCE as: SELECT answerID, COALESCE(option1, option2, option3, 'No ...
DA: 42 PA: 27 MOZ Rank: 96