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,

---

What is use of @@ spid in sql server?

0 Answers  

---

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

---

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

How does stuff differ from the replace function?

0 Answers  

---

What is sql server replication? : sql server replication

0 Answers  

---

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

How to loop through the result set with @@fetch_status?

0 Answers  

---

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

could u plz explain about joins and views?

2 Answers  

---

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

---

how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,

---