in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

How to use go command in "sqlcmd"?

0 Answers  

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---

Why we use functions in sql server?

0 Answers  

---

how many bits ip address consist of? : Sql server database administration

0 Answers  

---

wat is the main diff between sql server 2000and sql server 2005

6 Answers   Jade Software,

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

What is a raid and what are different types of raid configurations?

0 Answers  

---

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---

What is meant by referential integrity?

0 Answers   Blue Star,

---

What is deploy, process and build? : sql server analysis services, ssas

0 Answers  

---

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  

---