Re: sql question

David Cressey wrote:

> mmcdanie_at_teleport.com (Michael McDaniel) writes: > In article
> <348B572B.1D63_at_netvision.net.il>,
> > ministry of education <moe003_at_netvision.net.il> wrote:
> > }I have a table with multiple exact duplicate rows.No indexes. How
 do I
> > }delete all duplicate rows to get a single occurrence for each row?
> > }
> > }Thanx.
> >
> Pardon me for jumping in.
>
> first, create a clone of the original table with the same columns as
> the original table. Lets call them tableA and tableB.
>
> Now populate the new table as follows:
>
> insert into tableB
> select distinct * from tableA;
>
> This will eliminate exact duplicates as it copies the data to
> tableB.
>
> You can take it from here.

How about using rowid which is unique for each row.

Regards

Fateh
fateh.ahmad_at_cressoft.com.pk Received on Thu Dec 18 1997 - 00:00:00 CET