General information
Category:
Coding, syntax & commands
Title:
Best way to find duplicates?
I have 500,000 records and need to find the estimated 100
duplicate records based on 5 key fields. I would like to
keep the record with the highest dollar amount and delete
the others using the primary key.
I am toying with the idea of performing a SQL Select
and get records matching the group criteria with a count
greater than 1. However, I will not have the proper PK
when grouping. the other method is to sort the data and
then compare the current record versus the previous.
any thoughts on the best approach?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only