Hacker News new | ask | show | jobs
by SoftTalker 520 days ago
If you're including possibly NULL columns in a distinct or group by and you want to treat them in a particular way, use the COALESCE() or NVL() or whatever similar function to give a real value to the NULL for that purpose.