Home » SQL & PL/SQL » SQL & PL/SQL » Doubt in the query regarding deletion of duplicate records from the table
Doubt in the query regarding deletion of duplicate records from the table [message #236259] Wed, 09 May 2007 07:46 Go to next message
rashmi.uikey
Messages: 2
Registered: April 2007
Junior Member
Hi,

If i want to delete duplicate records from the table the query is,

delete from emp e1 where rowid > (select min(rowid) from emp e2 where e1.empno=e2.empno)

the logic over here is to delete duplicate records based on columns having duplicate values......but if my requirement is such tht my whole row is duplicate then how do i delete the records?
Re: Doubt in the query regarding deletion of duplicate records from the table [message #236260 is a reply to message #236259] Wed, 09 May 2007 07:54 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So enumerate all columns.

Regards
Michel
Previous Topic: no entry in dba_jobs_running
Next Topic: difference between two timestamps
Goto Forum:
  


Current Time: Sun Dec 11 00:35:09 CST 2016

Total time taken to generate the page: 0.09394 seconds