增长率的计算

Question

select sum(客户交费),(sum(客户交费)-t.s_last)/t.s_last
from tbname,(select sum(客户交费) s_last from tbname where to_char(交费周期,'yyyymm')='200304') t
where to_char(tbname.交费周期,'yyyymm')='200304';

Answer 1

select sum(客户交费),decode(t.s_last,0,100,(sum(客户交费)-t.s_last)/t.s_last)
from tbname,(select sum(客户交费) s_last from tbname where to_char(交费周期,'yyyymm')='200304') t
where to_char(tbname.交费周期,'yyyymm')='200304';