Re: Deletion of duplicate rows in a table

} } } Hi ! } } can somebody tell me how to delete duplicate rows from a table using a single } query in Informix. Is it possible in Ansi-Sql ? } } I tried using the following query but it is giving a syntax error : } } delete from table } where ( select column 1, column 2 } from table } group by column 1, column 2 } having count(*) > 1 ) } } Appreciate your response } } - Kishore } } Hi Kishore , I have missed something in the above post ... Extremely sorry ... } delete from table } where ( select column 1, column 2 } from table } group by column 1, column 2 } having count(*) > 1 ) U have to link the main query and the sub query ...... I will post it later ... Bye. Peter. mpeter.muc@sni.de