Re: delete duplicate rows, how???

No. There are complicated ways to do it with multiple SQL statements. Unless my memory is failing badly, I sent one such solution out in the last week or two -- please go and investigate a news archive such as DejaNews (http://www.dejanews.com) for the previous answer. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }From ilist@rmy.emory.edu Wed Jun 11 15:10 PDT 1997 }Date: Wed, 11 Jun 1997 14:37:43 -0700 (PDT) }From: Ramki Natesan <rnatesan@bactc.com> }To: informix-list@rmy.emory.edu }Subject: delete duplicate rows, how??? }X-Informix-List-Id: <list.14923> } }Hellow friends, } Is there a way to delete all the duplicate rows in a given table with }simple sql statement in Informix? } }/Ramki. }