Re: Deletion of duplicate rows in a table

Posted in 1996

cb — 21 Jun 1996 23:19:40 GMT — source: Informix-list mailing list archive (1991-1998)

If you're not going to use a correlated sub query try the folling: select x.rowid from same-table x, same-table y where x.rowid <> y.rowid and x.unique-col = y.unique-col and x.unique-col2 = y.unique-col2. You can retreive all the rowids that are duplicated and then delete those rowids or unload first and then delete.