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

5 Answers  

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  

---

Explain Geography datatype in SQL Server

0 Answers   Infosys,

---

how many instance use in sql server 2005

4 Answers   EFI, HCL,

---

What is GUID in sql server?

0 Answers   BirlaSoft,

---

---

What is policy based management (pbm)? : sql server database administration

0 Answers  

---

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

Explain trigger classes i.e. Instead of and after trigger?

0 Answers  

---

What are three SQL keywords used to change or set someone?s permissions?

3 Answers  

---

Explain system scalar functions?

0 Answers  

---

How to delete existing rows in a table?

0 Answers  

---

what are database files and filegroups? : Sql server database administration

0 Answers  

---