Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 74266 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / venki_discussions
delete from table (table name.a) where
rowid not in(select min(rowid) from (table name.b)
group by (column name);
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Explain oracle apps architecture.
What are file in oracle.
How can a process be deployed in soa?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
How is choreography different from orchestration?
what is pay run id ?
List the types of flexfield?
Are you familiar with internet architecture of oracle apps 11i?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
what is the difference between request group and request security in oracle apps?
Do you know what is applysys in oracle application database schema, what is apps?
tell my any difficult situtation you solved in your experience in your company?
How can you achieve loose coupling in soa framework?
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
