As we learn Pivot Table in the previous article.
UnPivot is another operation in SQL that perform almost reverse operation of Pivot by transfer data from rows to columns. Let us understand with an example.
- Create Student Table
CREATE TABLE Students ( Id INT PRIMARY KEY IDENTITY, [Student] VARCHAR(50), [Mathematics] INT, [Geography] INT, [Science] INT ) GO
- Insert Record To Student Table
INSERT INTO Students VALUES ('John', 78, 85, 91), ('Amit', 87, 90, 82)
- Before Applying Pivot Operator
SELECT * FROM Students
- After Applying The UnPivot Operator
SELECT [Student], [Subject], [Marks] FROM Students UNPIVOT ( [Marks] FOR [Subject] IN ([Mathematics], [Geography], [Science]) ) AS UnpivotTable
As you can see in the above figure, the Unpivot table has been created and we have converted the columns into distinct rows.
In this article, I have explained what is an Unpivot table in SQL and how to create one. I have also demonstrated a simple scenario in which I implement and use a pivot table.
Also, Check Pivot Table In SQL