Re: delete duplicate rows, how???

I don't know how to do it in Informix specifically, but what I would do in other DBMS's is create a second table of the same structure and do an "insert ... select distinct" from the first table into the second. Then drop the first table and rename the second to the first. Not quite 1 simple statement, but it will get the job done. Mike Dunham-Wilkie Ramki Natesan wrote: > > Hellow friends, > Is there a way to delete all the duplicate rows in a given table with > simple sql statement in Informix? > > /Ramki.