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

For example

Create table test as select distinct * from your_origin_table;

kalle
Paul Chu <chupaul_at_earthlink.net> wrote in message news:7ol3ur$47t$1_at_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 Mon Aug 09 1999 - 02:17:05 CDT