Re: Deleting duplicates

duanef_at_umich.edu (Any One) wrote:
> gave any one give me some sample code to delete duplicates? I have a
> table that now contains duplicate data (due to unforseen circumstances)
> that I need to clean up.
>

Try delete ORDER_HEADER x

     where  exists (select 'x'
                    from   ORDER_HEADER y
                    where  x.order_no = y.order_no
                    and    x.rowid   <> y.rowid
                    )

Rgds,
Buck Received on Wed Jun 19 1996 - 00:00:00 CEST