Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Duplicate records
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