delete from table (table name.a) where rowid not in(select min(rowid) from

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

Question Posted / venki_discussions

Answer Posted / venki_discussions

delete from table (table name.a) where
rowid not in(select min(rowid) from (table name.b)
group by (column name);

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we create tables in apps schema?

642

What is a flexfield? List out its types.

675

What does appl_top directory contain?

661

Is soa a part of oracle fusion middleware?

617

How to move the one file from one instance to another instance? And your scripts also?

619

Do you know what is applysys in oracle application database schema, what is apps?

685

In support project one ticket alloted which steps follows manualy tell me ?

2230

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

660

What are the Standard Reports and Forms in HRMS?

1778

List the types of flexfield?

615

What do you understand by soa?

701

Can you differentiate between mediator and osb?

636

Can u give the Documentation of Custom.pll in oracle apps

3000

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3092

tell my any difficult situtation you solved in your experience in your company?

1873