UnPivot Example
The following is an example of how to use the SQL UNPIVOT function. This function is almost the opposite of the PIVOT function.The UNPIVOT function takes specified columns and output them as rows.
Start with a table, [PivotExample2], with the following data:
RowID | GrpA | AA | BB | CC | DD | |
1 | XXX | 9 | 11 | 23 | 16 | |
2 | YYY | 30 | 18 | 8 | NULL |
To takes the values in columns [AA], [BB], [CC], & [DD], use the following query:
select up.GrpA, Val
from PivotExample2 a
unpivot
(
Val for Val1 in (AA, BB, CC, DD)
) as up
The above sql results in the following output:
GrpA|Val | |
XXX | 9 |
XXX | 11 |
XXX | 23 |
XXX | 16 |
YYY | 30 |
YYY | 18 |
YYY | 8 |
Related
Last modified by Mohit @ 4/5/2025 7:59:35 PM