Home » SQL & PL/SQL » SQL & PL/SQL » Duplicate Rows..
Duplicate Rows.. [message #216098] Thu, 25 January 2007 00:26 Go to next message
senthildurga
Messages: 9
Registered: December 2006
Junior Member
Could you please tell me how do i find the duplicate rows in a table?Thanks in advance...senthildurga
Re: Duplicate Rows.. [message #216102 is a reply to message #216098] Thu, 25 January 2007 00:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please search the forum before posting.
THe question is the most frequently asked one.
Re: Duplicate Rows.. [message #216187 is a reply to message #216098] Thu, 25 January 2007 08:24 Go to previous message
vijaykasi
Messages: 11
Registered: January 2007
Location: London
Junior Member
There are many ways to do this :

You can detect and delete duplicate rows using Oracle Analytic functions.

delete from
emp
where rowid in
(select rowid from
(select
rowid,
row_number()
over
(partition by empid order by empid) dup
from emp)
where dup > 1);
Previous Topic: query help / analytic functions / lead+lag
Next Topic: Merge problem (merged)
Goto Forum:
  


Current Time: Wed Dec 07 12:40:00 CST 2016

Total time taken to generate the page: 0.11853 seconds