HOW TO DELETE DUPLICATE

Posted in 1995

Timothy Hood — 12 May 1995 19:03:03 -0400 — source: Informix-list mailing list archive (1991-1998)

> -S.POTHIREDDY (siva@hogpe.ho.att.com) wrote: > : Could any body tell me how to delete duplicate rows in a table. I was > : able to list the duplicate rows in table like this: > F> Many solutions have appeared using 'rowid' (I like this one the best). > However, what happens when Informix stops using 'rowid' as in version > 7.1 with the table fragmentation feature? How can one then distinguish > rows from one another? You would need to replace "rowid" with your primary key column or columns. Tim --- ~ SPEED 1.40 [NR] ~