Re: Re: Using sql to delete duplicate records

Ok, I see how it works.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----rob@xxxxxxxxx wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: rob@xxxxxxxxx
Date: 10/06/2015 09:05AM
Subject: Re: Re: Using sql to delete duplicate records

I recreated it and used this technique and got the same results

delete from qtemp.dummy b
where rrn(b) >
(select min(rrn(a))
from qtemp.dummy a
where a.mychar = b.mychar
)
with nc
3 rows deleted from DUMMY in QTEMP.

select mychar, rrn(d)
from qtemp.dummy d
....+....1....+....2....+..
MYCHAR RRN ( D )
A 1
B 3
C 4
D 5



Rob Berendt