Which is more efficient GROUP BY or DISTINCT to find duplicates?

With more duplicates GROUP BY is more efficient, if only a few duplicates exist DISTINCT is more efficient.

Post a Comment