Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / ajith
DELETE FROM EMP E1
WHERE E1.ROWID>(SELECT MIN(E2.ROWID)
FROM EMP E2
WHERE E1.EMPNO=E2.EMPNO)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you explain the difference between architecture followed in 10g & 11g?
How is choreography different from orchestration?
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?
Do you know where we can check the status of po?
What do you understand by soa and what are the benefits of using this architecture?
How can we import the data into a database using sql * loader?
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
Do you know what is applysys in oracle application database schema, what is apps?
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
Explain what are the tables of auto invoice?
how can i print random rows in plsql table
What does appl_top directory contain?
what are the different transaction clauses in AR?
What are the benefits of using soa architecture?
what is the differences between internal requisition and internal sales order?