2
Answers

how to do convert rows into columns

narasiman rao

narasiman rao

7y
235
1
 
  i have emp table as follows

Empid Empname Month Salary

1 A 1 3000
2 B 2 5000
3 C 3 8000
4 D 4 9000
5 E 5 7000


from the above i want the output as follows


Empid Empname 1 2 3 4 5

1 A 3000 5000 8000 9000 7000


from getting a above output how to write the query in sql server
 
Answers (2)