DISTINCT vs GROUP BY for unique values

Question

Accepted Answer

For a single non-aggregate column, DISTINCT and GROUP BY produce identical results. The practical difference is extensibility: GROUP BY lets you add COUNT(*), SUM(), and other aggregates alongside the grouped column; DISTINCT does not. Neither guarantees any particular row order without an explicit ORDER BY. Both handle NULLs the same way - one NULL group.