Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 71474 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / amit shrivastava
Delete from table where rowid not in (select max(rowid)from
table group by column_name);
Delete from table T1 where rowid < (select min(rowid) from
table T2 where T1.emp_name=T2.emp_name);
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Can u give the Documentation of Custom.pll in oracle apps
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Tell me where we find the status of order information?
What do you understand by soa?
is it possible to run the interface without using oracle apps?
Do you know what is applysys in oracle application database schema, what is apps?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
can we get profile values in report without using user exists is it possible how?
How is choreography different from orchestration?
What do you understand by soa and what are the benefits of using this architecture?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
How can a process be deployed in soa?
In support project one ticket alloted which steps follows manualy tell me ?
What are do's and dont's of Interface?
tell my any difficult situtation you solved in your experience in your company?
