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
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)
Previous Topic: Re: Rollback to savepoints in a distributed transaction
Next Topic: SELECT help
Goto Forum:
  


Current Time: Sun May 31 19:12:22 CDT 2020