COALESCE in SQL — a practical guide to SQL COALESCE with clear examples you can reuse in real projects.
SQL Tutorial Series (46/100). Prefer one article? Read the complete SQL tutorial.
Short description
Ideal for fallback columns and portable null defaults.
Coalesce
SELECT COALESCE(phone, email, 'n/a') AS contact
FROM users;