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.

Re: Problem in duplicate record [message #18711 is a reply to message #18710] Mon, 11 February 2002 21:52 Go to previous message
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 Sep 19 02:01:37 CDT 2021