Re: Double entries

Posted in 1998

andy@pneu.com — Wed, 14 Oct 1998 05:55:01 GMT — source: Informix-list mailing list archive (1991-1998)

In article <3623982F.DAC18B8A@goofy.zdv.uni-mainz.de>, Andreas Lommel <lomman00@goofy.zdv.uni-mainz.de> wrote: > Hi > > I have a database with double entries. How can I locate and eliminate > them ? > > Thank you > > -- > ---------------------------- > Andreas Lommel > > mailto: lomman00@goofy.zdv.uni-mainz.de > > Hello Andreas! Pls try select row1, row2, row3, count(*) from anytable group by row1, row2, row3 HAVING count(*) > 1 into temp t_table with no log then re-select these rows with rowid, select min rowid and delete the row with the minimal rowid. Das ist meine L'sung. Andere sind nat'rlich m'glich! Bye and Tsch'ss Andy M. Bettin -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own