What is a Pivot Table?

A pivot table can aggregate and rotate data from rows to columns. You can also sort, count and aggregate the rows in one table and create a different table while displaying this summarized data. The PIVOT operator, in essence, turns the values of a specified column into column names, effectively rotating a table.

Pivot Table

SELECT *
FROM
(
  SELECT ticker, val, code
  FROM dbo.securities
) AS d
PIVOT
(
  MAX(val)
  FOR code IN (CUSIP, ISIN, BBGTICKER)
) AS piv 

Pivoted Table

As you can see, the resulting pivoted table has been converted so that for each ticker, you can see the CUSIP, ISIN, and BBGTICKER columns… All data is made up, and this bond indicative data is just for illustration purposes only.

Other Related Posts

• SQL Pivoting using Case Statement
  This tutorial discusses how to use the case statement , not only does it appear to be faster but there is more vendor support from the major databases.
• SQL Server Pivot Table Example
  This tutorial discusses the PIVOT operator, which in essence, turns the values of a specified column into column names, effectively rotating a table.

Please Share Us on Social Media