[Kannan S]

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

[shabbir]

Check Delete duplicate rows from Oracle

[sudhagar]

Quote:

Originally Posted by Kannan S

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]

Ya this is working dude