remove duplicate entries to a database?

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  November 18, 2006 at 8:24 am

  #175370

  I've an existing database with just over 4000 enties already in it, I've just decided to make one of the fields a unique field, but I've duplicate entries in the table, is there a quick fix that will allow me to remove the duplicates?

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  November 18, 2006 at 11:04 am

  #672801

  A quick search yielded the following:

  Finding and removing duplicates, Chris Cubley - article 

  Removing Duplicate Rows, Neil Boyle - article 

  Deleting Duplicate Records, Sureshkumar Ramakrishnan - article 

  Finding Duplicates Script by bcb 

  Identify Primary Key Violation Prior to Insert (Updated) script by kgayda 

  Finding and SHOWING Duplicates - PostSQL Statement to get rid of duplicates???? - Post 

  Hope this helps - this is a common question. 

  I wasn't born stupid - I had to study.

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  November 18, 2006 at 11:56 am

  #672803

  thanks Farrell

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  November 18, 2006 at 4:13 pm

  #672810

  You betcha! Nice to be thanked.

  I think this link is goofed up. Here is a better one...

  Identify Primary Key Violation Prior to Insert (Updated) script by kgayda 

  It's a link to another link...

  I wasn't born stupid - I had to study.