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

1 Answers  

---

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

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

what is hash table

3 Answers   ILFS, Teledata,

---

Explain transaction server isolation?

0 Answers  

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

0 Answers  

---

---

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

---

What is temporal table?

0 Answers  

---

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

What is molap and its advantage? : sql server analysis services, ssas

0 Answers  

---

What is sql sandbox in sql server?

0 Answers  

---

How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  

---

Explain error handling in ssis?

0 Answers  

---