Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   delete dup rows in oracle (http://www.go4expert.com/forums/delete-dup-rows-oracle-t21555/)

Kannan S 28Mar2010 11:30

delete dup rows in oracle
 
hi...dudes...
can anyone post the simplest ans for deleting duplicate rows in oracle....

shabbir 28Mar2010 14:28

Re: delete dup rows in oracle
 
Check Delete duplicate rows from Oracle

sudhagar 23Apr2010 10:55

Re: delete dup rows in oracle
 
Quote:

Originally Posted by Kannan S (Post 66346)
hi...dudes...
can anyone post the simplest ans for deleting duplicate rows in oracle....

try this one n let me know.. it will delete duplicate row from the table..


delete from employee t1 where exists(
select * from employee t2 where t2.name=t1.name and
t2.sa=t1.sa and t2.rowid>t1.rowid);

PRASOON 7Jun2010 10:01

Re: delete dup rows in oracle
 
Ya this is working dude


All times are GMT +5.5. The time now is 06:53.