Pivot in sql server

SELECT Y, [1] AS Q1, [2] AS Q2, [3] AS Q3, [4] AS Q4 FROM (SELECT Y, Q, Sales FROM SalesByQuarter) s PIVOT ( SUM(Sales) FOR Q IN ([1],[2],[3],[4]) ) p ORDER BY [Y] GO

Post a Comment