in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

---

How to write character string constants or literals in ms sql server?

0 Answers  

---

Where the sql logs gets stored? : sql server database administration

0 Answers  

---

Display a roll having miminum marks in two subjects?

7 Answers   Patni,

---

What is difference between stored procedure and function?

3 Answers   L&T,

---

Differentiate between a having clause and a where clause.

0 Answers  

---

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

---

Do you know clustered and non-clustered index?

0 Answers  

---

can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,

---

what command is used to create a table by copying the structure of another table?

7 Answers  

---

Do you know what are the ways available in sql server to execute sql statements?

0 Answers  

---