top of page
SQL TSQL Pivot
We is Pivot Unpivot in SQL
Pivot unpivot in SQL are two relation operator that used to Convert a table Expression into another
In Short Pivot and Unpivot in SQL are used to generate a multidimensional reporting.
Pivot :- in SQL Pivot is used to convert row Level to Column Level
Unpivot :- in SQL Pivot is used to convert Column Level to Row Level
![SS1.png](https://static.wixstatic.com/media/0008eb_d547459ff20b4be0aaff22fd77ca6e79~mv2.png/v1/fill/w_433,h_245,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/SS1.png)
![SQL Pivot using SQL Statment without Join.png](https://static.wixstatic.com/media/0008eb_ee043f2e376f43ae89938061ea97d623~mv2.png/v1/fill/w_398,h_379,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/SQL%20Pivot%20using%20SQL%20Statment%20without%20Join.png)
![SQL Pivot using SQL Statment.png](https://static.wixstatic.com/media/0008eb_9d0f052fa9fe414a9477c5777ab3b996~mv2.png/v1/fill/w_447,h_369,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/SQL%20Pivot%20using%20SQL%20Statment.png)
![SQL Pivot using TSQL .png](https://static.wixstatic.com/media/0008eb_89b8f07395984ef88be3fa5a12feac3d~mv2.png/v1/fill/w_529,h_350,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/SQL%20Pivot%20using%20TSQL%20.png)
bottom of page