Add a new "identity" column to the table. Assign sequential numbers to the identity column based on having the data sorted by the column that you want to eliminate duplicates in. Execute a delete statement that deletes records where the count of the duplicate value is > 0 and the value of the identity column is an odd number. The even numbered duplicates will remain in your database.