Re: Skill testing SQL question
From: Patrick Lanphier <planphier_at_psu.edu>
Date: Thu, 04 Nov 1999 17:34:16 -0500
Message-ID: <382209E8.60588B9_at_psu.edu>
Date: Thu, 04 Nov 1999 17:34:16 -0500
Message-ID: <382209E8.60588B9_at_psu.edu>
I would have done.
delete from DUPE_TABLE
where rowid IN (select max(rowid)
from DUPE_TABLE
group by AA, BB);
Patrick Lanphier
>
Received on Thu Nov 04 1999 - 23:34:16 CET