Discussion in 'Oracle' started by Kannan S, Mar 28, 2010.
can anyone post the simplest ans for deleting duplicate rows in oracle....
Check Delete duplicate rows from 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);
Ya this is working dude
Separate names with a comma.