delete from emp where rowid not in (select min(rowid) from emp group by e

How to remove duplicate rows from a table?.

Question Posted / lova raju allumalla

Answer Posted / lova raju allumalla

delete from emp where rowid not in (select min(rowid) from
emp group by empno);

Is This Answer Correct ?

7 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can a primary key be a foreign key?

968

What do you understand by pl/sql cursors?

1012

What is trigger price?

921

What does closing a cursor do?

1240

How to test for null values?

978

Is oracle and sql same?

953

Show the two pl/sql cursor exceptions.

1103

Is record in pl sql?

914

How show all rows in sql?

973

What is case function?

985

What are the different set operators available in sql?

970

what is union, minus and interact commands? : Sql dba

1115

What are all types of user defined functions?

1004

Write a query to display the current date in sql?

966

What are the types of variable use in pl sql?

1006