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..

How many schemas we have? how many you have used?

2005

---

What are the benefits of using soa architecture?

1182

---

Which oracle apps version you are very confident in?

1178

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2213

---

Do you know where we can check the status of po?

1191

---

what is global tempory table?

7129

---

What do you understand by a set of books?

1045

---

What are the different components of soa suite?

1148

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2576

---

Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

2315

---

where to define interorganization transaction charges and what are the different options?

2372

---

Do you know what are user profiles in apps. Any examples you can give?

1043

---

What are the Standard Reports and Forms in HRMS?

2230

---

Can you define an erp system?

1094

---

What is instead of trigger in where we will use?

1128

---