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,

---

How to rebuild indexes with alter index ... Rebuild?

0 Answers  

---

How to write a query with an inner join in ms sql server?

0 Answers  

---

What stored by the model?

0 Answers  

---

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

0 Answers  

---

---

What is sql server english query?

0 Answers  

---

When a primary key constraint is included in a table, what other constraints does this imply?

0 Answers  

---

How to count groups returned with the group by clause in ms sql server?

0 Answers  

---

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

---

What is a non-clustered index?

0 Answers  

---

Some queries related to SQL

0 Answers   Motorola,

---

What is the difference between varchar and varchar(max) datatypes?

0 Answers  

---