Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

---

How many types of schemas are there?

0 Answers  

---

write an SQL query to list the employees who joined in the month of January?

0 Answers   Agilent, Amdocs,

---

Describe in brief system database.

0 Answers  

---

What are the properties of the transactions?

0 Answers  

---

---

What is the recovery model?

0 Answers  

---

Explain error handling in ssis?

0 Answers  

---

What are the events recorded in a transaction log?

0 Answers  

---

can you any body tell me which service pack is installed in the sql server?

3 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

What is the default schema of your login session in ms sql server?

0 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---