GROUP BY vs DISTINCT

Question

Accepted Answer

For selecting unique values of a single column, DISTINCT and GROUP BY are interchangeable in result. The practical difference: GROUP BY lets you add aggregate columns (COUNT, SUM) alongside the grouped column; DISTINCT does not. Performance varies by database and indexes - neither is universally faster. Both handle NULLs the same way (one NULL group).