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?