謝謝了
這個是比較不錯在辦法
我下午問人寫出來了
select c.riqi, nvl( shouru,0)ru,nvl(zhichu,0), sum(shouru-zhichu) over (order by c.riqi) from (select( riqi+id) riqi from (select min (riqi) riqi,max(riqi) max_riqi from t1) a,
(select rownum-1 id from user_objects) b where riqi+id<max_riqi) c,t1 d where c.riqi=d.riqi(+)
通過這樣寫出~
謝謝了
這個是比較不錯在辦法
我下午問人寫出來了
select c.riqi, shouru,zhichu from (select( riqi+id) riqi from (select min (riqi) riqi,max(riqi) max_riqi from t1) a,
(select rownum-1 id from user_objects) b where riqi+id<max_riqi) c,t1 d where c.riqi=d.riqi(+)
通過這樣寫出~