How would you locate and eliminate duplicate records in a database table without deleting the original entries?