Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 74278 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
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
How many schemas we have? how many you have used?
How to move the one file from one instance to another instance? And your scripts also?
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
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
tell my any difficult situtation you solved in your experience in your company?
q)what are the validations in sql*loader
Which oracle apps version you are very confident in?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What is a value set? List its various types.
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
What do you understand by concurrent programs?
What do you understand by soa?
Can you explain the difference between architecture followed in 10g & 11g?
what is the difference between request group and request security in oracle apps?
