Program to delete duplicates?

MommyEnterprises · 07-15-2007, 06:56 PM

Does anyone know of a free program to delete duplicates?

**John Scott** · 07-15-2007, 06:58 PM

Duplicate what?

MommyEnterprises · 07-15-2007, 07:06 PM

I have a database I keep my customers info. If I select all the email addresses then there are many duplicates. I just need a simple program that will remove all the duplicates.

**John Scott** · 07-15-2007, 08:03 PM

Hmm. Sure there is one, but not that I know of.

Tinien · 07-16-2007, 12:58 AM

The best way is to make your own application

Musica · 07-17-2007, 02:34 AM

Hmm, not too sure which db you using assuming you are using mySQL, you can the following commands:

SELECT *, count(*) cnt FROM tableName GROUP BY fieldname1, fieldname2, .... HAVING cnt > 1

It will than return duplicates or entries with more than 1

If you using msSQL, you can read thier kb about this:
http://support.microsoft.com/default...b;en-us;139444

I also found this on softpedia, though personally I never use it before

http://www.softpedia.com/get/Interne...Software.shtml