查询的是一个由3个表做的视图，想要的结果是查询语句：
select userarea as '所在城市', scompany as '所服务4S店', substring(addtime,0,8) as '月份',SEPTEMBER as '当月指标', count(nid) as '销售数量',cast(cast(count(nid) as float)/cast(SEPTEMBER as float) as decimal(12,2)) as '指标达成率', sum(cast(re23 as int)) as '销售总金额' from View_CarWarehouse
where 1=1 and addtime>'2013-08-31' and state!='0'
group by userarea,scompany,substring(addtime,0,8),SEPTEMBER因为当月指标是要跟局月份来确定的
真心拜求个可以解决此问题的方法sql
select userarea as '所在城市', scompany as '所服务4S店', substring(addtime,0,8) as '月份',SEPTEMBER as '当月指标', count(nid) as '销售数量',cast(cast(count(nid) as float)/cast(SEPTEMBER as float) as decimal(12,2)) as '指标达成率', sum(cast(re23 as int)) as '销售总金额' from View_CarWarehouse
where 1=1 and addtime>'2013-08-31' and state!='0'
group by userarea,scompany,substring(addtime,0,8),SEPTEMBER因为当月指标是要跟局月份来确定的
真心拜求个可以解决此问题的方法sql
为什么年和月份都分开写呢~ 把年 1-12月 弄成YYYY-MM 不好么