Re: Skill testing SQL question
From: <rtproffitt_at_my-deja.com>
Date: Thu, 04 Nov 1999 22:00:45 GMT
Message-ID: <7vsvmb$eon$1_at_nnrp1.deja.com>
Date: Thu, 04 Nov 1999 22:00:45 GMT
Message-ID: <7vsvmb$eon$1_at_nnrp1.deja.com>
Argosy,
Even simpler...
This correlated Delete
delete from dupes a
where rowid >
(select min(rowid)
from dupes b
where a.aa = b.aa
and a.bb = b.bb)
Robert Proffitt
Beckman Coulter
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Nov 04 1999 - 23:00:45 CET