1.

A simple example of Pivot table in SQL Server(Column into Row)?

Answer»

A simple example of Pivot table in SQL Server(Column into Row)?
Below is the example to CREATE a OUTPUT in form of Pivot Table or column into row. First i have create a below table.


SQL Table

And i need a output like below:-



SQL Pivot Table

Now below is the QUERY to get the output as above by using pivot table.




SQL Pivot Query



Discussion

No Comment Found