What is Pivot and Unpivote?

What is Pivot and Unpivote?

A pivot table is basically use for the sorting the table, and also doing the work in table like a counting and totaling the data which is stored in one table or spread sheet and its also create the second table for the display the summarized data,It can be turns the value of a specified column into column names, effectively rotating a table. but in case of Unpivote Its a exactly opposite to the pivote.

Date:2013-01-09 00:00:00

Post Your Answers

User Email:

User Name:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher