select * from ( select t1.cvid as '销售客户编号',t3.cvname as '客户名称' ,sum(decode(to_char(t1.ct,'yyyymm'),'201409',t1.sale_mny,0)) as '9月销售' ,sum(decode(to_char(t1.ct,'yyyymm'),'201410',t1.sale_mny,0)) as '10月销售' ,sum(decode(to_char(t1.ct,'yyyymm'),'201411',t1.sale_mny,0)) as '11月销售' ,sum(t1.sale_mny) as '汇总金额' from sd_salelogd t1,sd_salebill t2,bd_cvdoc t3 where t1.cvid=t2.cvid and t2.cvid=t3.cvid and to_char(t1.ct,'yyyymm') in('201409','201410','201411') group by t1.cvid,t3.cvname) t order by 9月销售,10月销售,11销售 desc
select t1.cvid as '销售客户编号',t3.cvname as '客户名称'
,sum(decode(to_char(t1.ct,'yyyymm'),'201409',t1.sale_mny,0)) as '9月销售'
,sum(decode(to_char(t1.ct,'yyyymm'),'201410',t1.sale_mny,0)) as '10月销售'
,sum(decode(to_char(t1.ct,'yyyymm'),'201411',t1.sale_mny,0)) as '11月销售'
,sum(t1.sale_mny) as '汇总金额'
from sd_salelogd t1,sd_salebill t2,bd_cvdoc t3
where t1.cvid=t2.cvid and t2.cvid=t3.cvid
and to_char(t1.ct,'yyyymm') in('201409','201410','201411')
group by t1.cvid,t3.cvname) t
order by 9月销售,10月销售,11销售 desc