delete dup rows in oracle

Kannan S's Avatar
Newbie Member
hi...dudes...
can anyone post the simplest ans for deleting duplicate rows in oracle....
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Check Delete duplicate rows from Oracle
0
sudhagar's Avatar, Join Date: Apr 2010
Light Poster
Quote:
Originally Posted by Kannan S View Post
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);
0
PRASOON's Avatar
Newbie Member
Ya this is working dude