oracle列递归累加sql代码实例,oracle递归累加sql
查询压岁钱表age_money
select * from age_money;
year1 money 2001 10 2002 20 2003 20 2004 5 2005 10
递归累加
WITH T AS ( select year1,money from age_money where order by year1 ) SELECT T.year1,T.money, SUM(T.money) OVER(ORDER BY T.year1) as Recursion_Accumulate FROM T
year1 money RECURSION_ACCUMULATE 2001 10 10 2002 20 30 2003 20 50 2004 5 55 2005 10 65
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。