Delete from table_name where ROWID not in ( select max(rowid) from table g

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

Question Posted / ravi kant yadav

Answer Posted / ravi kant yadav

Delete from table_name where ROWID not in ( select
max(rowid) from table group by duplicate_values_field_name);

Regards
ravi

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

3424

Which oracle apps version you are very confident in?

1178

What are file in oracle.

2182

Can we create tables in apps schema?

1086

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

2073

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

2612

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

1057

List the various types of value set.

1024

What are the benefits of using soa architecture?

1182

What are the Standard Reports and Forms in HRMS?

2230

How many schemas we have? how many you have used?

2005

please send me forms, xml pulisher questions,answers

2069

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3007

what is the differences between internal requisition and internal sales order?

2604

What do you understand by a set of books?

1045