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 see the event list of an existing trigger using sys.trigger_events?

0 Answers  

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

How to list all triggers in the database with sys.triggers in ms sql server?

0 Answers  

---

How adventureworkslt tables are related?

0 Answers  

---

---

What is an example of a foreign key?

0 Answers  

---

Which institute is best for SQL Server 2005 Training?

6 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  

---

Name three of the features managed by the surface area configuration tool? : sql server security

0 Answers  

---

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

0 Answers  

---

Explain about Joins?

0 Answers   Infosys,

---

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

---