UnPivot Table In SQL

Introduction

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
  • Output

  • After Applying The UnPivot Operator
SELECT
  [Student],
  [Subject],
  [Marks]
FROM Students
UNPIVOT
(
[Marks]
FOR [Subject] IN ([Mathematics], [Geography], [Science])
) AS UnpivotTable
  • Output

As you can see in the above figure, the Unpivot table has been created and we have converted the columns into distinct rows.

Conclusion

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

Submit a Comment

Your email address will not be published. Required fields are marked *

Footer Logo

Subscribe

Select Categories