Home » SQL & PL/SQL » SQL & PL/SQL » Problem in duplicate record
Problem in duplicate record [message #18710] Mon, 11 February 2002 20:37 Go to next message
kuldeep singh
Messages: 2
Registered: February 2002
Junior Member
Respected Sir
I have a table with duplicate record and duplicate record may be more than two now i want to delete all duplicate record and want to have one copy of each.
so tell me how can i do it.

Regards
kuldeep

Report message to a moderator

Re: Problem in duplicate record [message #18711 is a reply to message #18710] Mon, 11 February 2002 21:52 Go to previous message
dhanraj
Messages: 12
Registered: February 2002
Junior Member
try this
delete from table a
where rowid>(select min(rowid) from table where recno=a.recno)

Report message to a moderator

Previous Topic: Re: Rollback to savepoints in a distributed transaction
Next Topic: SELECT help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 14:00:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.