Which Is More Efficient Group By Or Distinct To Find Duplicates?

1.	Which Is More Efficient Group By Or Distinct To Find Duplicates?
Answer» With more DUPLICATES GROUP BY is more EFFICIENT, if only a few duplicates EXIST DISTINCT is more efficient. With more duplicates GROUP BY is more efficient, if only a few duplicates exist DISTINCT is more efficient.

Answer»

With more DUPLICATES GROUP BY is more EFFICIENT, if only a few duplicates EXIST DISTINCT is more efficient.

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

Discussion