Tuesday, 27 September 2016

How to convert Result Rows into Columns in sqlserver

Query:
---------
SELECT [Year],
       MAX(CASE WHEN [hour] = 1
           THEN [rate] END) AS Q1,
       MAX(CASE WHEN [hour] = 2
           THEN [rate] END) AS Q2,
       MAX(CASE WHEN [hour] = 3
           THEN [rate] END) AS Q3,
       MAX(CASE WHEN [hour] = 4
           THEN [rate] END) AS Q4
FROM [dbo].[test]
GROUP BY Year

No comments:

Post a Comment