delete from tablename where rowid not in(select min(rowid) from table nam

Write an SQL Query to
Delete Duplicate records from a table using ROWID.

Question Posted / veera

Answer Posted / veera

delete from tablename where rowid not in(select min(rowid)
from table name group by duplicate record col)

Is This Answer Correct ?

37 Yes

21 No

Please Help Members By Posting Answers For Below Questions

Tell me where we find the status of order information?

667

What is count(*) from po_vendors(any table)?

643

Can you define an erp system?

681

please send me forms, xml pulisher questions,answers

1654

In sequence i want to 11 and 15th values how we will write?

1573

Explain oracle apps architecture.

767

Is soa a part of oracle fusion middleware?

607

do you know is it possible to run the interface without using oracle apps?

650

Can you differentiate between mediator and osb?

627

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

636

can we use look up type instead of a pofile option?or valueset?is it possible how?

1787

Can we create tables in apps schema?

622

How do you register report in oracle apps?

632

List the various types of value set.

622

Do you know where we can check the status of po?

637