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

What are the benefits of using soa architecture?

709


List the types of flexfield?

605


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2092


What is oracle soa suite?

766


Can you differentiate between mediator and osb?

627






Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

1888


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

1708


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

674


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

1614


How can a process be deployed in soa?

700


Tell me how to debug the report?

639


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

2128


Can you explain the difference between architecture followed in 10g & 11g?

659


In sequence i want to 11 and 15th values how we will write?

1573


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

662