22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM (SELECT Convert(varchar(2),DATEPART(month, dtime))+'月' m
chenid,
SUM(production) sump
FROM 数据表
WHERE DATEPART(year, dttime) = 2001
) p
PIVOT (SUM(sump) FOR chenid in ('1号称','2号称',...,'7号称') T
SELECT *
FROM (SELECT Convert(varchar(2),DATEPART(month, dtime))+'月' m
chenid,
SUM(production) sump
FROM 数据表
WHERE DATEPART(year, dttime) = 2001
GROUP BY Convert(varchar(2),DATEPART(month, dtime))+'月',
chenid
) p
PIVOT ...