Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Which SQL pattern finds duplicate records?

  1. A GROUP BY the key columns with HAVING COUNT(*) greater than 1
  2. B SELECT DISTINCT
  3. C ORDER BY the key columns
  4. 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.

All Data MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as