Re: deleting duplicate rows
From: Have software <sobczak_at_tplab.enet.dec.com>
Date: Thu, 6 Aug 1992 09:17:39 GMT
Message-ID: <1992Aug6.091739.25314_at_decuk.uvo.dec.com>
Date: Thu, 6 Aug 1992 09:17:39 GMT
Message-ID: <1992Aug6.091739.25314_at_decuk.uvo.dec.com>
How about this ?
delete from wfi_master a where exists
(select * from wfi_master b where
b.reg_no = a.reg_no and
b.cassette_no > a.cassette_no);
Piotr Received on Thu Aug 06 1992 - 11:17:39 CEST