delete from <tablename> rowid not in (select max(rowid) from <ta

write a query to delete similar records in same table

Question Posted / apurva

Answer Posted / apurva

delete from <tablename> rowid not in (select max(rowid)
from <tablename> group by <col.name where there are
repeating records>);

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is sql workbench free?

945

how to install mysql? : Sql dba

1058

What is aggregate function in sql?

996

What are the operators used in select statements?

1008

How to write html code in pl sql?

1072

What is materialized view in sql?

879

What are the different types of dbmss?

974

What is the difference between cross join and natural join?

972

How we can update the view?

1011

What is sql and its types?

1123

What do you understand by pl/sql cursors?

1034

When is the update_statistics command used?

1055

What is a unique key?

1013

What is a database? Explain

1060

How do you write an index?

917