Information générale
Catégorie:
Codage, syntaxe et commandes
>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?
I wrote an app that dup checks using this code:
select * as Total_Dups
from Table
group by Key
having count(*) > 1
order by Key
into table HoldFile
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement