Home » SQL & PL/SQL » SQL & PL/SQL » How to delete duplicate records? (splitted topic)
How to delete duplicate records? (splitted topic) [message #209746] Sun, 17 December 2006 08:44 Go to next message
praful.ghagi
Messages: 3
Registered: December 2006
Location: adfasd
Junior Member

hi experts,
i have problem on sql duplication row how to delete duplicate
rows in table please easy query to understand me
Re: please kindly help its urgent [message #209748 is a reply to message #209746] Sun, 17 December 2006 08:54 Go to previous messageGo to next message
praful.ghagi
Messages: 3
Registered: December 2006
Location: adfasd
Junior Member

hi Expert

how to delete duplicate rows in table using rowid
please send me query.
Re: please kindly help its urgent [message #209758 is a reply to message #209748] Sun, 17 December 2006 11:05 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This question has been answered many times; I'd suggest you to check this OraFAQ page.

Also, it is not a good idea to attach .doc files - some people (including me) aren't big fans of opening such a files from an unknown source. You'd better put this text into the topic, or - if you really need to attach it - use .txt format.
Re: please kindly help its urgent [message #209856 is a reply to message #209758] Mon, 18 December 2006 03:26 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
@praful.ghagi:
  • Please, do not duplicate your messages.
  • Do not ask such questions in other people's topics which are not related with your problem (deleting duplicated records has nothing to do with "Mathematical Theory of Structured Query Language").
  • Use Test forum to see how your topics and messages appear in different ways - test it!
Re: How to delete duplicate records? (splitted topic) [message #405851 is a reply to message #209746] Sat, 30 May 2009 04:46 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

delete FROM TABLE1
WHERE ROWID IN (SELECT ROWID FROM (SELECT ROW_NUMBER() OVER (PARTITION BY COLUMN1,COLUMN2
ORDER BY COLUMN1,COLUMN2) rnk
FROM TABLE2 where CLOUMN1=<ANY CONDITION IF YOU WANT>)
WHERE rnk>1);



Javed
Re: How to delete duplicate records? (splitted topic) [message #405857 is a reply to message #405851] Sat, 30 May 2009 07:36 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
What is the fun in replying to a 2006 post?
Also it is answered earlier.

By
Vamsi
Previous Topic: DDL TRIGGER
Next Topic: compilation errors in stored procedure
Goto Forum:
  


Current Time: Sun Dec 11 07:56:21 CST 2016

Total time taken to generate the page: 0.04522 seconds