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

Does truncate release storage space?

1082

What is full join?

961

How to start the command-line sql*plus?

1058

What is the meaning of disabling a trigger?

1182

How long does it take to learn pl sql?

1064

Explain how can you save or place your msg in a table?

1029

What are the limitations of sql express?

1071

how to see the create table statement of an existing table? : Sql dba

1019

What does select count (*) mean in sql?

1022

Enlist some predefined exceptions?

1063

what are all different types of collation sensitivity? : Sql dba

982

How can we find duplicate records in a table?

948

Are stored procedures faster than queries?

948

How do I enable sql encryption?

1035

What is primary key in db?

1011