Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / samad
delete from emp a where rowid >(select min(rowid) from emp
b where a.rowid = b.rowid);
2. DELETE FROM EMP A
WHERE ROWID > ( SELECT min(ROWID) FROM EMP B WHERE
A.ROWID = B.ROWID)
cheers
samad
| Is This Answer Correct ? | 21 Yes | 18 No |
Post New Answer View All Answers
tell me the scenarios of the independent in reports
please send me forms, xml pulisher questions,answers
What is the concept of soa governance?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
how can i print random rows in plsql table
What do you understand by soa?
do you know is it possible to run the interface without using oracle apps?
tell me the scenarios of the independent in reports
How to create a purchase order without a requisition?
What are the different components of soa suite?
what are the prerequisites for costing transactions?
testing tools?
Which oracle apps version you are very confident in?
In support project one ticket alloted which steps follows manualy tell me ?
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