narasiman rao

narasiman rao

  • NA
  • 519
  • 768.6k

how to do convert rows into columns

Mar 18 2017 9:11 AM
 
  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)