Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Duplicate records

Re: Duplicate records

From: Angelika Betz <abetz_at_keyzone.at>
Date: Fri, 04 May 2001 14:24:01 +0200
Message-ID: <3AF29F61.B5EC74F2@keyzone.at>

delete from table where id=??? and rownum<2

then 1 row only will be deleted

kurt_at_kurti.cc

"GĂ©rard EDMOND" wrote:

> How can I delete duplicate records from a table which has no primary key?
  Received on Fri May 04 2001 - 07:24:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US