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

Answer Posted / parthasarathi

delete tab1 where (col1_dup,rowid) in (select
col1_dup,max(rowid) from tab1 where group by col1_dup having
count(col1_dup)>1);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different components you should consider while defining a responsibility in oracle apps?

620


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

1667


How can we import the data into a database using sql * loader?

659


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2431


How can you achieve loose coupling in soa framework?

699






what are the prerequisites for costing transactions?

2616


Do you know what are user profiles in apps. Any examples you can give?

636


what is the difference between request group and request security in oracle apps?

5014


List the types of flexfield?

581


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2573


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

605


How is choreography different from orchestration?

630


What do you understand by concurrent programs?

596


Is soa a part of oracle fusion middleware?

589


What is a flexfield? List out its types.

642