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 to find 3rd highest salary of an employee from the employee table in sql?

1130

What are the basic techniques of indexing?

1111

How can get second highest salary in sql?

1025

Is sql pronounced sequel or sql?

1338

Which sorts rows in sql?

1055

What is sql lookup?

970

What is function and procedure in pl sql?

1116

How do you rank data in sql?

1067

How to know the last executed procedure?

1156

What is primary key and foreign key?

1011

What is field delimiter?

1110

How to change the order of columns in Oracle SQL Plus ?

1102

what are date and time data types in mysql? : Sql dba

1020

Explain the difference between rename and alias?

1063

how to convert character strings to numeric values? : Sql dba

1162