Answer / mohamed idhris

SET ROWCOUNT 1

DELETE FROM tbl_name WHERE field_name= 'field_value'

SET ROWCOUNT 0


the above query will delete the duplicate row

Answer / rakesh pattajoshi

delete from tbl where id not in(select max(id) from tbl group by name)

Answer / priya

use distinct.it removes the duplicate rows

Answer / ranjitha

Add Primary Key to the table.

Explain the five stages in a dlx pipeline? : Dot net architecture

0 Answers  

---

Navigation controls in ASP.net,explain each control in brief?

2 Answers   Six Sigma,

---

What is .net mobile forms? : Microsoft dot net mobile

0 Answers  

---

which would be the best to use inproc,outproc or sql server

2 Answers   Ness Technologies,

---

There are so many languages are already existing for developing application.Then what is the need of .net.

1 Answers  

---

does .NET support multiple inheritance ?

13 Answers   Ness Technologies,

---

difference between Response.write,server.transfer and also which one is used when ?

0 Answers  

---

what is meant by language interoperability and language integration?

1 Answers   Six Sigma,

---

Are there any third party logging components available?

0 Answers  

---

What should one do to make class serializable?

1 Answers  

---

What is static Constructor?

4 Answers   iGate,

---

How cache is used? : Dot net architecture

0 Answers  

---