Write a Query to Delete The Repeated Rows from emp table?

Oracle Apps Interview Questions › Category: SQL › Write a Query to Delete The Repeated Rows from emp table?

0 Vote Up Vote Down

Questions Master asked 12 years ago

Write a Query to Delete The Repeated Rows from emp table;

1 Answers

0 Vote Up Vote Down

Shailender Thallam Staff answered 12 years ago

DELETE FROM emp WHERE rowid NOT IN
(SELECT MIN(rowid) FROM emp GROUP BY ename
);