delete from table_name where rowid not in(select min(rowid) from table

write a query to delete similar records in same table

Question Posted / nirmalendu

Answer Posted / nirmalendu

delete from table_name where rowid not in(select min(rowid)
from table_name group by column_name);

** column_name which having duplicate record

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you explain an index number?

786

What is pessimistic concurrency control? : Transact sql

864

What is a pragma statement?

1005

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

844

How does rowid help in running a query faster?

1197

What is a behavioral trigger?

735

What is on delete restrict?

778

Does varchar need length?

743

In what condition is it good to disable a trigger?

795

What is meant by temporal data?

747

Can we rollback truncate?

765

What is dynamic sql in pl sql?

748

What is compound trigger?

778

How do I make my sql query run faster?

716

What is primary key secondary key alternate key candidate key?

816