Home > DeveloperSection > Interviews > What is PIVOT and UNPIVOT?

Posted on    May-11-2011 5:17 AM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  3126  View(s)
Rate this:

Awadhendra Tiwari

Total Post:510

Points:2550
Posted on    May-11-2011 12:00 AM

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.


Don't want to miss updates? Please click the below button!

Follow MindStick