Return the first non-NULL expression.
Section: json and string functions
Use COALESCE for fallback values
sql
sql
SELECT COALESCE(display_name, full_name, email) AS label FROM users;Explanation
Great for optional columns and layered display fallbacks.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing json and string functions