Re: Need to delete duplicate rows

Karl Hewlett wrote in message
<8dgiks$jk2$1_at_scream.auckland.ac.nz>...
>Someone suggested select distinct into a temp table which will
 work, another
>solution would be:
>
>(Its been a while since I have had to do this so you may have to
 play with
>the syntax)
>
>delete from sales a
>where rowid = (select max(b.rowid)
> where a.item_code = b.item_code
> and <snip>
> );

IIRC, you are on an AS/400. On the '400, use

where rrn(a) = (select max(rrn(b))
etc.

--
Cheers,
Simon Brunning
TriSystems Ltd.
sbrunning_at_trisystems.co.uk
The opinions expressed are mine, and are not necessarily those of my
employer.