PIVOT relational operator converts data from row level to column level. PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output. Using PIVOT operator, we can perform aggregate operation where we need them.

What is a pivot query?

A pivot query helps you summarize and revisualize data in a table. … For example a pivot table can help you see how many data points of a particular kind are present, or it can represent your data by aggregating it into different categories.

Why do we use pivoting?

You can use pivot tables to sort, reorganize, group, count, total or average data stored in a database. They are the perfect solution when you need to summarize and analyze large amounts of information. That way, you get to put your raw data into meaningful insights in a single table – and this brings many benefits.