What is pivot Operator ?? Why use Pivot Operator
- MS Sql Server
- 736
- March-30-2018
- by Rizwan Saqib
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 |
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
you can view the more detail via link https://www.youtube.com/watch?v=HpZgwHU1GcIChing xang
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Danial Comb
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!