Delete duplicate rows without using rowid.

0 Answers   Nagarro,

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  

---

How do I find query history in sql server?

0 Answers  

---

How to select some specific rows from a table in ms sql server?

0 Answers  

---

Explain for xml explicit mode?

0 Answers  

---

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

---

What do you understand by triggers?

0 Answers  

---

What are types of subqueries?

0 Answers  

---

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

Can two tables share the same primary key?

0 Answers  

---

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

---