I show that DISTINCT and GROUP BY are usually interchangeable, but there are cases where one performs better than the other.