Re: Deleting duplicates

duanef_at_umich.edu (Any One) writes:

>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.

   delete from &&musor h1 where exists    (select * from &&musor h2 where h1.rowid=h2.rowid    intersect
   select * from &&musor h3 where h1.rowid > h3.rowid )

Where &&musor is the actual table name.

I receive it from Alexandr Pechkarev <pech_at_zgik.zaporizhzhe.ua> on Fri, 26 Aug 1994 10:01:18 +0200 (UKR)

I hope it will help you.
But it will work slowly.

Valery Yourinsky

--
SoftService, Moscow
Oracle Corp. Distributor
tel (095) 976-34-78, 976-43-13 
tel/fax (095) 976-01-33