query to display row values in to column value

Question

Name	month	val
suresh	jan	12000
praveen	feb	14000
Raja	mar	13000

 

 

OUTPUT

Name      suresh          Praveen      Raja

Month     jan                  feb             mar --------- dec        total

 

Val          12000           14000          13000  ------        1000

Hi:

Can any one send me the  Sql Query  to achieve the following task.

Write query to display row values in to column value