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

Answer Posted / sushmitha

This link provides different methods of removing duplicate
rows from table

http://www.besttechtools.com/SQLArticles.aspx?
ID=DeleteDuplicate

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

669


What is sca and how is it useful?

645


What do you understand by concurrent programs?

609


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

1857


please send me forms, xml pulisher questions,answers

1645






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

1772


What does appl_top directory contain?

631


What do you understand by soa?

678


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

2143


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2577


Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

1557


What is instead of trigger in where we will use?

663


What do you understand by a set of books?

636


Tell me how to debug the report?

625


In hierarchical structure of a database? we have write query from where we should start?

1690