Home » SQL & PL/SQL » SQL & PL/SQL » Identifying duplicate rows in a column
Identifying duplicate rows in a column [message #184743] Thu, 27 July 2006 13:17 Go to next message
Rolex
Messages: 4
Registered: July 2006
Location: Tamil Nadu
Junior Member
how can we delete the complete row with redundant entries in a particular column?
Re: Identifying duplicate rows in a column [message #184749 is a reply to message #184743] Thu, 27 July 2006 13:59 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://www.orafaq.com/scripts/sql/deldup.txt

http://cheblogs.com/roller/page/nimzobenoni?entry=redundant_duplicates_removal_with_rowid
Previous Topic: Problem with a job in Replication Environment
Next Topic: Regarding materialized view
Goto Forum:
  


Current Time: Wed Dec 07 04:41:28 CST 2016

Total time taken to generate the page: 0.13335 seconds