Re: Deleting duplicate rows from a table:SQL Command???
From: Albert L Evans <ae0i+_at_andrew.cmu.edu>
Date: Wed, 29 Sep 1993 22:23:53 -0400
Message-ID: <UgeYAtm00WB=EbF3Ua_at_andrew.cmu.edu>
Date: Wed, 29 Sep 1993 22:23:53 -0400
Message-ID: <UgeYAtm00WB=EbF3Ua_at_andrew.cmu.edu>
An easier version to type in:
DELETE FROM TABLE_1 X WHERE MAX(ROWID) NOT IN
(SELECT ROWID FROM TABLE_1
WHERE X.ID_DATE=ID_DATE
AND X.ID=ID)
A similar statement will work for any table by modifiying the key components.
This statement is extremely slow, but the only method I've run across for
deleteing dups.
Bert Evans Received on Thu Sep 30 1993 - 03:23:53 CET