Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 71481 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
can we get profile values in report without using user exists is it possible how?
How is choreography different from orchestration?
testing tools?
What is oracle soa suite?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
what is the differences between internal requisition and internal sales order?
How can we import the data into a database using sql * loader?
Do you know what are user profiles in apps. Any examples you can give?
Can you define an erp system?
Do you know where we can check the status of po?
where to define interorganization transaction charges and what are the different options?
What do you understand by soa?
what are the balancing segments in AR?
How to create a purchase order without a requisition?
What are the different components of soa suite?
