如何使用pivot函数，使用datepart字段

问题描述

WeekNumber WeeklyCount
11 100
10 200
9 300
8 400
7 500

WeekNumber   11  10   9   8   7
WeeklyCount 100 200 300 400 500

SELECT Top 5     DatePart(ww, DATE) as weekNumber, Count(id) as WeeklyCount
    FROM         dbo.AL
   Where DatePart(ww, DATE) <> DatePart(ww, GetDate())
    group by  DatePart(ww, DATE)
    order by DatePart(ww, DATE) desc

Pivot function query

推荐答案

尝试这样：

SELECT [11], [10], [9], [8], [7]
FROM (YourQueryHERE) AS DT
PIVOT(SUM(WeeklyCount) FOR WeekNumber IN([11], [10], [9], [8], [7])) AS PT

如果你想要动态版本，请看我的评论;）

If you want dynamic version, please see my comment ;)

这篇关于如何使用pivot函数，使用datepart字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！