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 number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form. What is the exact procedure on hardware that converts the ascii value to binary? : .NET Architecture

1 Answers  

---

Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form. What is the exact procedure. : Dot net architecture

1 Answers  

---

What is the purpose of Treeview control?

1 Answers   CGI,

---

What is the purpose of hard disk? : Dot net architecture

1 Answers  

---

Explain difference between machine config vs. Web config? : .NET Architecture

1 Answers  

---

Define cache coherency and how is it eliminated? : Dot net architecture

1 Answers  

---

Explain about httpruntime.cach.get(); method?

1 Answers   Tech Mahindra,

---

What is .net mobile automatic paging? : Microsoft dot net mobile

1 Answers  

---

Explain Singleton design pattern in .net

1 Answers   Infosys,

---

How can a win service developed in .NET be installed or used in Win98?

1 Answers  

---

Explain domestic architecture artifacts? : .NET Architecture

1 Answers  

---

How is the using() pattern useful? What is idisposable?

1 Answers  

---