Delete Duplicate query. Deletes duplicates. But I need for it to keep one record once it deletes
Posted on 2013-01-25
I have a query that finds the duplicates and deletes them. This works fine. However, it deletes all the duplicates of a certain record. I need for it once it finds a duplicate delete it but just keep one of the records.
Meaning delete all but one, once you find the duplicates.
DELETE [Serial ].*, tblInductionCheckHistory.Serial
WHERE (((tblInductionCheckHistory.Serial) In (SELECT [Serial] FROM [tblInductionCheckHistory] As Tmp GROUP BY [Serial] HAVING Count(*)>1 )));