Sql Server Pivot Table

A Pivot Table can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data. The PIVOT operator turns the values of a specified column into column names, effectively rotating a table.

Table stracture with table test:
The Month colums contain the month number from 1 to 12.By the help of pivot table we can convert rows data into coulms.

Pivot query:
—————————————————————–
SELECT *
FROM
(
SELECT name,MONTH,salary
FROM test

) p
PIVOT
(
sum (salary)
FOR [month]
IN ([1], [2], [3],[4], [5], [6],[7],[8],[9],[10],[11],[12])
) AS pvt;
——————————————————————

Result display by this query :

try the example the you will understand the working of pivot table.