查询每个月的某个字段的值

select  sum(case when  datepart(month,EndTime)=1 then ShareValue else 0 end) as '1月',
        sum(case when  datepart(month,EndTime)=2 then ShareValue else 0 end) as '2月',
        sum(case when  datepart(month,EndTime)=3 then ShareValue else 0 end) as '3月',
        sum(case when  datepart(month,EndTime)=4 then ShareValue else 0 end) as '4月',
        sum(case when  datepart(month,EndTime)=5 then ShareValue else 0 end) as '5月',
        sum(case when  datepart(month,EndTime)=6 then ShareValue else 0 end) as '6月',
        sum(case when  datepart(month,EndTime)=7 then ShareValue else 0 end) as '7月',
        sum(case when  datepart(month,EndTime)=8 then ShareValue else 0 end) as '8月',
        sum(case when  datepart(month,EndTime)=9 then ShareValue else 0 end) as '9月',
        sum(case when  datepart(month,EndTime)=10 then ShareValue else 0 end) as '10月',
        sum(case when  datepart(month,EndTime)=11 then ShareValue else 0 end) as '11月',
        sum(case when  datepart(month,EndTime)=12 then ShareValue else 0 end) as '12月'
    from [Parking].[dbo].[PK_Order]
    where datepart(year,EndTime)='2019' and Status = '1'

case.... when... then... else... end

case when  datepart(month,EndTime)=1 then ShareValue else 0 end

当 字段 datepart(month,EndTime)=1  时 就+ShareValue,如果字段不等于1时,就+0,