Xref: alice comp.databases.oracle.misc:37987
Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!newsfeed.direct.ca!newsfeed.berkeley.edu!newsfeed1.earthlink.net!nntp.earthlink.net!posted-from-earthlink!not-for-mail
From: "Paul Chu" <chupaul@earthlink.net>
Newsgroups: comp.databases.oracle.misc
Subject: PL/SQL: best way to find and remove duplicate rows ( keep 1 row )
Date: Sun, 8 Aug 1999 16:28:13 -0700
X-Posted-Path-Was: not-for-mail
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-ELN-Date: 8 Aug 1999 23:30:35 GMT
X-ELN-Insert-Date: Sun Aug  8 16:35:04 1999
Organization: EarthLink Network, Inc.
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MSMail-Priority: Normal
Lines: 10
Message-ID: <7ol3ur$47t$1@ash.prod.itd.earthlink.net>

Hi all,

I would like a script which would find all the duplicate rows in the table
and keep 1 of the duplicate rows and delete the others.

Any suggestions.

Regards, Paul