27,580
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM (
SELECT 次数,
CONVERT(varchar(2),DATEPART(month,日期))+'月份' m,
DATEPART(day,日期) d
FROM table1
) t
PIVOT (
MAX(次数)
FOR d IN ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10],
[11], [12], [13], [14], [15], [16], [17], [18], [19], [20],
[21], [22], [23], [24], [25], [26], [27], [28], [29], [30],
[31])
) p