“All things will be clear and distinct to the man who does not hurry; haste is blind and improvident.”
- Titus Livius
The Distinct Command
DISTINCT eliminates duplicates from returning in the Answer Set.
Distinct vs. GROUP BY
Distinct and GROUP BY in the two examples return the same answer set.
Rules of Thumb for DISTINCT vs. GROUP BY
Rules for Distinct Vs. GROUP BY
(1) Many Duplicates – use GROUP BY (2) ...