Re: sql question

[This followup was posted to comp.databases.informix and a copy was sent to the cited author.] In article <348B572B.1D63@netvision.net.il>, moe003@netvision.net.il says... > 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. > You could try a select with the distinct option and populate another table then drop the original table and rename the new to have the same name as the first one. -- Michael J. Erickson (Michael_Erickson@iname.com) Any opinions expressed here are my own and do not necessarily reflect those of my employer or clients.