RE: Duplicate Data Delete

Posted in 2005

Alejandro Mendoza — Thu, 1 Sep 2005 15:31:42 -0500 — source: Usenet: comp.databases.informix

You can use ROWID to filter the rows to delete. SELECT ROWID,* FROM <table>Then use the rowid for the row you want delete. DELETE FROM <table> WHERE ROWID=#### -----Mensaje original----- De: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] En nombre de Prashant Shirude Enviado el: Jueves, 01 de Septiembre de 2005 10:15 a.m. Para: informix-list@iiug.org Asunto: Duplicate Data Delete Does any one has a query to delete duplicate data? I need a query to delete duplicate data. --Prashant Database Analyst sending to informix-list sending to informix-list