环比同比

SELECT 
    TEMP.*,
    NVL(round(((TEMP.CollectionAmount + TEMP.StayCollectionAmount) / lag(TEMP.CollectionAmount + TEMP.StayCollectionAmount) over(order by TEMP.MonthID)) * 100, 2), '0') || '%' "环比",
    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') || '%' "同比" 
FROM
    (SELECT 
        *
    FROM 
        tds_agent_org_revcoll_mon T
    WHERE 
        T.companyId = -1
            AND T.MonthID >= '201601'
            AND T.MonthID <= '201707') TEMP

参考lag和lead函数。

^_^