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);