What is pivot Operator ?? Why use Pivot Operator
By Rizwan Saqib   Posted on March-30-2018 673
MS Sql Server
Pivot is very usefull and important Operator in SQL Because if we want to convert Rows in Columns then we use Pivot Operator and One Column Define Differnt Result set
For Example
We have table Of Daily Income
ID | Vendor | IncomeDay | Income Amount |
|
1 | Rehman | January | 200 | |
2 | Adil | Feburary | 500 | |
3 | Jameel | March | 1000 | |
4 | Adil | January | 900 | |
5 | Jameel | January | 800 | |
6 | Rehman | Feb | 2000 | |
7 | Jameel | Feb | 4000 |
We want To change Months Columns in Row In this Situation we Use Pivot operator
Select * From
(
Select Vendor, IncomeDay, Income Amount
from Daily Income
)
Src
Pivot
(
Sum( Income Amount) For IncomeDay In
([January],[Feb],[March])
) As PivotTable
It Give us Result like This
Vendor | January | Feb | March |
Rehman | 200 | 2000 | Null |
Adil | 900 | 500 | Null |
Jameel | 900 | 4000 | 1000 |
By Rizwansaqib966   30-Mar-2018
Views 673