Oops
From: Albert L Evans <ae0i+_at_andrew.cmu.edu>
Date: Wed, 29 Sep 1993 22:26:14 -0400
Message-ID: <8geYD6O00WB=QbF44s_at_andrew.cmu.edu>
Date: Wed, 29 Sep 1993 22:26:14 -0400
Message-ID: <8geYD6O00WB=QbF44s_at_andrew.cmu.edu>
My previous message should read:
DELETE FROM TABLE_1 X WHERE ROWID NOT IN
(SELECT MAX(ROWID) FROM TABLE_1
WHERE X.ID_DATE=ID_DATE
AND X.ID=ID)
Sorry... mixed up the rowid and max(rowid).
Bert Evans Received on Thu Sep 30 1993 - 03:26:14 CET