Re: Help: How could I delete two identical rows from one table?
From: (wrong string) öström <lasse.sjostrom_at_telia.com>
Date: Tue, 14 Dec 1999 15:26:32 GMT
Message-ID: <Ikt54.298$y3.186563072_at_newsb.telia.net>
Date: Tue, 14 Dec 1999 15:26:32 GMT
Message-ID: <Ikt54.298$y3.186563072_at_newsb.telia.net>
Use the rowid, they are always different. And a proper max-function on rowid, i.e. do a select deleting all rows with everything the same, except the rowid.
Lars
your_name skrev i meddelandet
<945183430.789806_at_newsreader-hpw1.net.bms.com>...
>Folks,
>I run a procedure twice by mistake. Now I have two sets
>of identical row, each has about 3000 records. Could someone tells me how
>could I delete one set of them?
>Or I have to re-create the table, which will be terrible.
>
>Thanks for your help
>
>
Received on Tue Dec 14 1999 - 16:26:32 CET