Re: delete duplicate rows, how???
In <5nn7km$c4n@cssun.mathcs.emory.edu> rnatesan@bactc.com (Ramki
Natesan) writes:
>
>Hellow friends,
> Is there a way to delete all the duplicate rows in a given table
with
>simple sql statement in Informix?
>
>/Ramki.
Hi:
If you don't mind using rowids which is a no-no with fragmented tables:
select some_dup_col from sometab a, sometab b where a.some_dup_col =
b.some_dup_col and a.rowid != b.rowid
Hey! no flames. you can do it. I'm not recommending it.
regards,
Ed
Schaefer