首页 > 其他 > 详细

环比同比

时间:2017-10-12 18:45:05      阅读:274      评论:0      收藏:0      [点我收藏+]
 1 SELECT 
 2     TEMP.*,
 3     NVL(round(((TEMP.CollectionAmount + TEMP.StayCollectionAmount) / lag(TEMP.CollectionAmount + TEMP.StayCollectionAmount) over(order by TEMP.MonthID)) * 100, 2), 0) || % "环比",
 4     NVL(round(((TEMP.CollectionAmount + TEMP.StayCollectionAmount) / lag(TEMP.CollectionAmount + TEMP.StayCollectionAmount) over(partition by SUBSTR(to_char(TEMP.MonthID), 5, 2) ORDER BY TEMP.MonthID)) * 100, 2), 0) || % "同比" 
 5 FROM
 6     (SELECT 
 7         *
 8     FROM 
 9         tds_agent_org_revcoll_mon T
10     WHERE 
11         T.companyId = -1
12             AND T.MonthID >= 201601
13             AND T.MonthID <= 201707) TEMP

参考lag和lead函数。

^_^

环比同比

原文:http://www.cnblogs.com/gotodsp/p/7657284.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!