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:22:42 +0200
Message-ID: <3AF29F12.18C05D52@keyzone.at> 






delete from table where id=4711 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:22:42 CDT












Original text of this message













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