Which SQL pattern finds duplicate records?
- A GROUP BY the key columns with HAVING COUNT(*) greater than 1
- B SELECT DISTINCT
- C ORDER BY the key columns
- D UNION ALL
Answer
GROUP BY the key columns with HAVING COUNT(*) greater than 1
Deciding what constitutes a duplicate matters first: an exact row copy differs from two records for the same customer spelled differently.





