Re: sql question

David Cressey wrote: > mmcdanie@teleport.com (Michael McDaniel) writes: > In article > <348B572B.1D63@netvision.net.il>, > > ministry of education <moe003@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@cressoft.com.pk