select
b.yun_id,
b.yun_yaerm,
b.amount,
b.yun_name,
b.HB，
b.tb,
c.amount,
c.yun_yaerm ,
nvl( round((c.amount -b.amount)/b.amount,2),0),
d.amount,
d.yun_yaerm,
nvl( round((d.amount -b.amount)/b.amount,2),0)
from lichengyun b
left join
lichengyun c on
to_date(b.yun_yaerm,'yyyy-mm-dd') = add_months(to_date (c.yun_yaerm ,'yyyy-mm-dd') ,-1)
left join
lichengyun d on
to_date(b.yun_yaerm,'yyyy-mm-dd') = add_months(to_date (d.yun_yaerm ,'yyyy-mm-dd') ,-12)
uj5u.com熱心網友回復：
1、如果是10g以后版本，可以看看分析函式（視窗函式）；2、還可以通過with as構建不同年月的臨時表實作。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/28138.html
標籤：開發