We help IT Professionals succeed at work.

query to delete duplicate records in SQL server

Medium Priority
727 Views
Last Modified: 2012-05-06
Can anyone please give me the query to delete duplicate records in SQL server?
Comment
Watch Question

you'll have to be more specific.... do you have an identity field? PK?

-John
That depends on your table design and what criteria you are using to say that two records are equal.
Can you give us this info?
In any case this may help:
http://www.sql-server-performance.com/articles/dba/delete_duplicates_p1.aspx
You may just have to tinker with it depending on your criteria for duplicateness

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.