Ok, I see how it works.
STAR BASE Consulting, Inc.
-----rob@xxxxxxxxx wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
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) >
from qtemp.dummy a
where a.mychar = b.mychar
3 rows deleted from DUMMY in QTEMP.
select mychar, rrn(d)
from qtemp.dummy d
MYCHAR RRN ( D )
This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact