Re: Help! Deleting duplicate rows

From: AleX <korrozia_at_my-deja.com>
Date: Thu, 16 Sep 1999 02:01:10 GMT
Message-ID: <7rpj11$eag$1@nnrp1.deja.com>

In article <37DFE29F.8D7B0E91_at_gwl.com>, Dogan Cibiceli <dcib_at_gwl.com> wrote:
> sjoshi_at_ingr.com wrote:
>
> > Hello All
> > Can someone please tell me how to delete duplicate rows from a
table
> > in Oracle 8.0.4
> >
> > thanks
> > Sunit
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
>
> delete from table where rowid in ( select max(row_id) from table group
> by all_fields)
>
>

Make it

delete from table where rowid not in ( select max(row_id) from table group by all_fields;

yeah?
by all_fields)

                 Alex Shterenberg

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 15 1999 - 21:01:10 CDT