自己对照你的修改一下:with t as
(select 10 tot
from dual
union all
select 11 tot
from dual
union all
select 13 tot
from dual
union all
select 9 tot
from dual
union all
select 1 tot
from dual
union all
select 17 tot
from dual)
select tot, rn, sum(tot) over(order by rn)
from (select tot, rownum rn from t);
(select 10 tot
from dual
union all
select 11 tot
from dual
union all
select 13 tot
from dual
union all
select 9 tot
from dual
union all
select 1 tot
from dual
union all
select 17 tot
from dual)
select tot, rn, sum(tot) over(order by rn)
from (select tot, rownum rn from t);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货