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 are the types of subqueries?

570

What is scalar data type in pl sql?

552

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

551

What is the basic form of sql query?

493

What is an oracle stored procedure?

587

What is an exception in PL/SQL? What are the two types of exceptions?

626

Is sql a case sensitive language?

514

Explain table and field in sql?

581

Define implicit and explicit cursors.

626

How is pl sql different from sql?

545

Why do we need cursor in pl sql?

647

what tools available for managing mysql server? : Sql dba

529

Can I create table without primary key?

529

how to select unique records from a table? : Sql dba

629

What is null in pl/sql?

624