What are Pivot Tables ? In SQL How to Create Pivot Tables ?
Pivot tables are used to generate table of statistics from a given table.
It is a table where we put some summary from a given table. In this summary we can put sums, averages, count or other statistics, which the pivot table groups together in a meaningful way.



