Write a Query To Delete The Repeted Rows from emp table;

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 672
Delete from emp where rowid not in(select min(rowid)from emp group
by ename)

Comments or Responses

Login to post response