Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL: best way to find and remove duplicate rows ( keep 1 row )

PL/SQL: best way to find and remove duplicate rows ( keep 1 row )

From: Paul Chu <chupaul_at_earthlink.net>
Date: Sun, 8 Aug 1999 16:28:13 -0700
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



Received on Sun Aug 08 1999 - 18:28:13 CDT












Original text of this message













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