Delete duplicate record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a table with 10,000 rows and 10 columns.

Column 1 has text values, I want to delete the record if they have a
duplicate, that is delete all the records.

So if Column 1 has a two, three, four,... rows with the same value I would
delete
ALL the two, three, four... rows.

I have a query that finds the duplicate, but how do you delete this?

Thanks for your help on this
 
Dear Jeff,

You could create an exact same table structure without any records. In that
new table make the column 1 the primary key. Then append the table.
 
I just read what I wrote and it didn't make sense. Let me rephrase what I
wrote. Create a new table with exact same table structure. Make column 1 a
primary key then append all the records.
 
Back
Top