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

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2616

What do you understand by soa?

1160

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

1978

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

1123

Tell me how to find the custom directory in front end?

1111

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

1089

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3065

tell me the scenarios of the independent in reports

2626

How to create a purchase order without a requisition?

1197

What do you understand by concurrent programs?

1101

What are the Standard Reports and Forms in HRMS?

2318

What does appl_top directory contain?

1122

What do you understand by soa and what are the benefits of using this architecture?

1088

What are the different components of soa suite?

1209

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2131