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
- 77946 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / ankit kumar srivastava
DELETE FROM EMP_a WHERE ROWID NOT IN(
(SELECT MAX(ROWID) FROM EMP_a a GROUP BY
EMPNO,ENAME,sex,doj,sal,deptno,mgr HAVING COUNT(ROWID)
=1)
UNION
(SELECT MAX(ROWID) FROM EMP_a a GROUP BY
EMPNO,ENAME,sex,doj,sal,deptno,mgr HAVING COUNT(ROWID)>1))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
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
Can you explain the difference between architecture followed in 10g & 11g?
Do you know what is applysys in oracle application database schema, what is apps?
Do you know what are user profiles in apps. Any examples you can give?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
what is the difference between request group and request security in oracle apps?
What are do's and dont's of Interface?
What are file in oracle.
What is oracle soa suite?
Tell me where we find the status of order information?
where to define interorganization transaction charges and what are the different options?
what is the differences between internal requisition and internal sales order?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
how do you describe O2C along with tables
