Re: Help! Deleting duplicate rows

From: Dogan Cibiceli <dcib_at_gwl.com>
Date: Wed, 15 Sep 1999 12:17:03 -0600
Message-ID: <37DFE29F.8D7B0E91@gwl.com>

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) Received on Wed Sep 15 1999 - 13:17:03 CDT

This message: [ Message body ]
Next message: Karen Abgarian: "security news in oracle 8?"
Previous message: Jonathan Lewis: "Re: fast growing RBSs"
In reply to: sjoshi_at_ingr.com: "Help! Deleting duplicate rows"
Next in thread: AleX: "Re: Help! Deleting duplicate rows"
Reply: AleX: "Re: Help! Deleting duplicate rows"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US