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

How do I truncate a word?

1079

Name the operator which is used in the query for pattern matching?

935

what is the difference between join and union? : Sql dba

1104

Can %notfound return null after a fetch?

1050

How we can update the view?

1043

How to start oracle sql developer?

1024

How does cross join work in sql?

1007

How many tables can a sql database have?

971

What is sqlca in powerbuilder?

1000

What is rowid in sql?

975

What is rollback?

1105

how to increment dates by 1 in mysql? : Sql dba

970

How do you copy a table in sql?

1059

What is file based approach?

933

What are the dml statements?

1137