RE: Best Way to find duplicate records in same file

Then how about:

Select KEYFIELD, COUNT(*), MAX(RRN(TABLE))
>From COLLECTION.TABLE
Group by KEYFIELD
Having COUNT(*)>1

For each record in the result set, chain by RRN and delete. Keep running
until result set is empty.

> -----Original Message-----
> From: Mark Allen
> 
> Actually what I need it to do is delete the dups:
> 
> Record 1: ABCDEFGHIJKL
> Record 2: ABCDEFGHIJKL
> Record 3: 123456789012
> 
> I want to delete record 2
> 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Metz Zak
> 
> Well here's your SQL method and I thinks it's pretty clean:
> 
> Select KEYFIELD, COUNT(*)
> >From COLLECTION.TABLE
> Group by KEYFIELD
> Having COUNT(*)>1
NOTICE: This E-mail may contain confidential information. If you are not
the addressee or the intended recipient please do not read this E-mail
and please immediately delete this e-mail message and any attachments
from your workstation or network mail system. If you are the addressee
or the intended recipient and you save or print a copy of this E-mail,
please place it in an appropriate file, depending on whether
confidential information is contained in the message.