I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

---

What is logshipping and its purpose?

0 Answers  

---

What command do we use to rename a database?

0 Answers  

---

What is used to replicate sessions between instances in coldfusion clusters?

0 Answers   HCL,

---

---

What do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---

What do you mean by stored techniques? How would we use it?

0 Answers  

---

Why Do you want to work in this company?

4 Answers   HCL,

---

How to divide query output into multiple groups with the group by clause in ms sql server?

0 Answers  

---

How do SQL server 2000 and XML linked?

2 Answers  

---

What are the steps you should follow to start sql server in single-user mode?

0 Answers  

---

What are logical/boolean operations in ms sql server?

0 Answers  

---