WHAT IS PIVOT AND UNPIVOT IN SQL?

Sumit Kesarwani

Total Post:0

Points:0
Posted by  Sumit Kesarwani
 1352  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    What is PIVOT and UNPIVOT in SQL?

    A Pivot Table can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data. The PIVOT operator turns the values of a specified column into column names, effectively rotating a table.

    UNPIVOT table is reverse of PIVOT Table.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!