Answer Posted / parthasarathi

delete T1
from MyTable T1, MyTable T2
where T1.dupField = T2.dupField
and T1.uniqueField > T2.uniqueField ;


Try this will work for SQL Server and My Sql but not for
MSAccess .....

For MSAccess try the below one

delete from MyTable
where uniqueField not in
(select min(uniqueField) from MyTable T2
where T2.dupField=MyTable.dupField);

The above query also works for SqlServer but not for MySql..

tell me the scenarios of the independent in reports

2565

---

In support project one ticket alloted which steps follows manualy tell me ?

2710

---

Tell me where we find the status of order information?

1194

---

What do you understand by soa?

1194

---

what is the difference between request group and request security in oracle apps?

5976

---

Can you define an erp system?

1222

---

How can a process be deployed in soa?

1334

---

What are the different components of soa suite?

1265

---

Do you know what is applysys in oracle application database schema, what is apps?

1221

---

What are file in oracle.

2286

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3110

---

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

3732

---

please send me forms, xml pulisher questions,answers

2159

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2671

---

how can i print random rows in plsql table

2571

---