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>


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

Original text of this message