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
---------
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