Re: Q: Duplicate records
From: Martin Jarvis <smj_at_jbecpor.demon.co.uk>
Date: Mon, 25 Jan 1993 17:42:48 +0000
Message-ID: <C1F7vC.Huu_at_jbecpor.demon.co.uk>
Date: Mon, 25 Jan 1993 17:42:48 +0000
Message-ID: <C1F7vC.Huu_at_jbecpor.demon.co.uk>
Oracle's Technical Bulletin, March 1992
DELETE FROM tablename
WHERE ROWID NOT IN
( SELECT MAX(ROWID) FROM tablename
GROUP BY keycolumn1, keycolumn2, etc )
Received on Mon Jan 25 1993 - 18:42:48 CET