在一个表中,如何用SQL语句计算增长率?
在一个表中,如何用SQL语句计算增长率?
表：date(月份) num（量）
2012-01 29
2012-02 60
2012-03 90
2012-04 100
增长率=本月量/上月量-1；如何算出每个月的增长率?
表：date(月份) num（量）
2012-01 29
2012-02 60
2012-03 90
2012-04 100
增长率=本月量/上月量-1；如何算出每个月的增长率?
赞 zz飞燕 花朵
共回答了18个问题采纳率：83.3% 举报
with AAA as (
select '200101' month,29 num from dual
union
select '200102' month,34 num from dual
union
select '200103' month,54 num from dual
union
select '200104' month,56 num from dual
union
select '200105' month,78 num from dual
)
select t1.month,t1.num,
case
when trunc((t1.num-t2.num)/t1.num,2) is not null
then(trunc((t1.num-t2.num)/t1.num,2)||'%')
else
'--'
end rate
from AAA t1,AAA t2 where t1.month-1=t2.month(+) order by t1.month
select '200101' month,29 num from dual
union
select '200102' month,34 num from dual
union
select '200103' month,54 num from dual
union
select '200104' month,56 num from dual
union
select '200105' month,78 num from dual
)
select t1.month,t1.num,
case
when trunc((t1.num-t2.num)/t1.num,2) is not null
then(trunc((t1.num-t2.num)/t1.num,2)||'%')
else
'--'
end rate
from AAA t1,AAA t2 where t1.month-1=t2.month(+) order by t1.month
1年前
4
可能相似的问题
-
1年前1个回答
你能帮帮他们吗
精彩回答