select max(case month(his_date) when 1 then His_Value end) as '1',max(case month(his_date) when 2 then His_Value end) as '2',
max(case month(his_date) when 3 then His_Value end) as '3',max(case month(his_date) when 2 then His_Value end) as 'bjd',
His_Stat,His_Type from L_His where year(his_date)>=2005 and his_date<'2006-3-31' group by His_Stat,His_Type max(case month(his_date) when 2 then His_Value end) as 'bjd' 求1,2,3月的统计 就是第一季度的统计怎么写啊???
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货