1+2+3 公式
求公式
1 =1
2 =1+2
3 =1+2+3
4 =1+2+3
5 =1+2+3+4+5的和
。
。
求和的公式
[解决办法]
with tb as(
select 1 as a from dual union all
select 2 from dual union all
select 3 from dual union all
select 4 from dual union all
select 5 from dual
)
select a.a,sum(b.a) from tb a,tb b where a.a>=b.a
group by a.a
order by a.a
with t as
(
select 1 c1 from dual union all
select 2 c1 from dual union all
select 3 c1 from dual union all
select 4 c1 from dual union all
select 5 c1 from dual
)
select c1,sum(c1) over(order by rownum) tl
from t
c1 tl
-----------------------
111
223
336
4410
5515
