Q: delete duplicates, how?
From: Rune Lysbakken <lysbakke_at_online.no>
Date: Thu, 11 Feb 1999 07:54:06 GMT
Message-ID: <36c28c6b.388959_at_news.online.no>
[Quoted] [Quoted] I want to create an unique index but I have some duplicate values. I [Quoted] think I can find them with a combination of count, group and having Count ()> 1 but how can I delete so that only one of the duplicates remains? Use rowid perhaps?
Date: Thu, 11 Feb 1999 07:54:06 GMT
Message-ID: <36c28c6b.388959_at_news.online.no>
[Quoted] [Quoted] I want to create an unique index but I have some duplicate values. I [Quoted] think I can find them with a combination of count, group and having Count ()> 1 but how can I delete so that only one of the duplicates remains? Use rowid perhaps?
regds Rune Received on Thu Feb 11 1999 - 08:54:06 CET