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

What is data type in database?

933

What is scope of pl sql developer in future?

952

What is pl sql quora?

1073

How do you use a while loop in pl sql?

942

Is postgresql a server?

997

What are aggregate and scalar functions?

978

Is mariadb nosql?

994

How to return an array from java to pl/sql?

1063

What are the set operators in sql?

1032

Advantages and disadvantages of stored procedure?

1061

What are the 3 modes of parameter?

1103

How do you exit in sql?

1065

What is an index in sql with example?

920

What is basic structure of pl sql?

990

Which one is faster ienumerable or iqueryable?

866