SELECT curmonth MONTH,
((curmonth_sum - lastyear_sum) / lastyear_sum * 100) identical,
((curmonth_sum - lastmonth_sum) / lastmonth_sum * 100) annulus,
FROM (select t.SALARYMONTH as curmonth
,t.SALARY as curmonth_sum
,LAG(t.SALARY, 12, NULL) OVER (ORDER BY t.SALARYMONTH) AS lastyear_sum
,LAG(t.SALARY, 1, NULL) OVER (ORDER BY t.SALARYMONTH) AS lastmonth_sum
from (select SALARYMONTH as SALARYMONTH
,INDEXNAME as INDEXNAME
,sum(SALARY) as SALARY
from d_month_salary
group by SALARYMONTH,
INDEXNAME ) t
where t.INDEXNAME = 'id' )
oracle 计算同比环比的函数
最新推荐文章于 2022-07-23 16:21:53 发布