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

How exception is different from error?

1022

What is AUTH_ID and AUTH_USER in pl/sql ?

2197

Why are aggregate functions called so?

952

Is sql procedural language?

972

What is rtm stands for?

1107

Is join same as left join?

1043

Why do we need a foreign key?

1104

What is sql engine in oracle?

995

What are different joins used in sql?

1062

What is data definition language?

1097

What is the non-clustered index in sql?

1067

What are the string functions in sql?

984

What is the usage of sql functions?

1150

What is left join in sql?

1056

What are some emotional triggers?

988