WHAT IS PIVOT AND UNPIVOT IN SQL?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
 1192  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!