if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

---

---

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

0 Answers   HCL,

---

What are the different types of backups avaialabe in sql server 2005?

0 Answers  

---

What Are Three Rules to Use UNION IN SQL SERVER

1 Answers  

---

Explain about integration services of Microsoft SQL server?

0 Answers  

---

What is the advantage of sql server?

0 Answers  

---

How to find the last update record in SQL Server?

4 Answers  

---

Explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---