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  

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---

What is a partitioned view?

0 Answers  

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

---

What are secondary xml indexes?

0 Answers  

---

Can a function call a stored procedure in sql server?

0 Answers  

---

how can i lock the column in the table

2 Answers   Accenture,

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

How to round a numeric value to a specific precision?

0 Answers  

---

what is a traditional network library for sql servers? : Sql server database administration

0 Answers  

---

Explain full-text query in sql server?

0 Answers  

---