Re: Deletion of duplicate rows in a table

Posted in 1996

R M Sams — Sat, 22 Jun 1996 00:54:54 GMT — source: Informix-list mailing list archive (1991-1998)

Susik_Lee@United#u#Group.CCMAIL.CompuServe.COM posted : >> echo "unload to junk.unl select * from table" | isql database | sort | >> uniq > junk.load; >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 love the uniq command. Nowadays I use 'sort -u' which sorts and 'unique's also. -Sams