Home » SQL & PL/SQL » SQL & PL/SQL » how to delete duplicate rows?
how to delete duplicate rows? [message #330721] Tue, 01 July 2008 00:59 Go to next message
krithi86
Messages: 19
Registered: June 2008
Location: India
Junior Member
Table name EMP
Rows are as follows

Name Age
aaa 21
aaa 21
aaa 21
bbb 22
bbb 22
ccc 23

there are No constraint.how to delete the duplicate rows and how to identify which is the duplicate row?
Re: how to delete duplicate rows? [message #330722 is a reply to message #330721] Tue, 01 July 2008 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.google.com/search?hl=en&q=delete+duplicate+rows&btnG=Google+Search
Results 1 - 10 of about 371,000

Are you saying you didn't find the answer in those 371,000 posts?

Regards
Michel
Re: how to delete duplicate rows? [message #330724 is a reply to message #330721] Tue, 01 July 2008 01:01 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One way would be to search the board or visit OraFAQ FAQ's; you'll find several solutions to your problem. So, instead of being spoonfed, you'll actually learn something.
Re: how to delete duplicate rows? [message #330726 is a reply to message #330722] Tue, 01 July 2008 01:03 Go to previous messageGo to next message
krithi86
Messages: 19
Registered: June 2008
Location: India
Junior Member
thanks for all u guys critisizing replies
Re: how to delete duplicate rows? [message #330736 is a reply to message #330726] Tue, 01 July 2008 01:29 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I believe that you are wrong, Krithi86.

Although you'd probably be happier if someone posted a query which would delete duplicate records from your table, you'd simply run it and forget about it. Next time you'd come back again and ask for help on deleting another duplicates from another table.

But if you, actually, do some research on the subject and learn HOW it is done and WHY you have to follow certain rules, you'd learn it and easily implement this knowledge to another, possibly very different problem.
Previous Topic: using Spool in procedure
Next Topic: How to find out if a session is hung?
Goto Forum:
  


Current Time: Sat Dec 10 12:40:09 CST 2016

Total time taken to generate the page: 0.09280 seconds