Interested to Buy Any Domain ? << Click Here >> for more details...
Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 78509 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
Tell me how to debug the report?
What is instead of trigger in where we will use?
what are the balancing segments in AR?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
What is a flexfield? List out its types.
What does appl_top directory contain?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
What are file in oracle.
Plz anybody send me Technical specification for AP Interface
What are the benefits of using soa architecture?
What are the Standard Reports and Forms in HRMS?
do you know is it possible to run the interface without using oracle apps?
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
can we get profile values in report without using user exists is it possible how?
what is the differences between internal requisition and internal sales order?
