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  

---

How does recursive cte works in sql server?

0 Answers  

---

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---

Can you please differentiate between a primary key and a unique key?

0 Answers  

---

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,

---

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

2 Answers   IBM, TCS,

---

Define constraints and give an example of their use?

0 Answers  

---

Is the order of columns in the set clause important in ms sql server?

0 Answers  

---

What is best institute to Learn DotNET And SQL in chennai?

0 Answers  

---

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,

---

What is snapshot replication?

0 Answers  

---

How to download and install microsoft .net framework version 2.0?

0 Answers  

---