Çóoracle ²éѯÓï¾ä

RemainIntegral µÄÖµÊÇËûÇ°ÃæµÄ getintegral µÄºÍ

¸ÄÔõôд°¡£¡£¿ Çë¸ßÊÖ°ï棡

---

getintegral  RemainIntegral

16              16
18              34
15              49

²»ºÃÒâ˼ͼƬûÏÔʾ³öÀ´£¡
  ÈçÉÏÃæÎÒдµÄ

---

select sum(getintegral)over(parition by 1 order by getintegral)from ±í

---

ºÃÏñ²»ÐÐŶ ȷʵÓÒÀ¨ºÅ
  ÎÒÒªµÃµ½µÄÊÇ ºÜ¶àÌõ¼Ç¼ ¶ø²»ÊÇÒ»Ìõ
  ûÌõ¼Ç¼µÄ getintegral  RemainIntegral
µÄÖµ ÈçÉÏÃæÎÒËù˵µÄ

---

ÒýÓÃ

ºÃÏñ²»ÐÐŶ ȷʵÓÒÀ¨ºÅ
  ÎÒÒªµÃµ½µÄÊÇ ºÜ¶àÌõ¼Ç¼ ¶ø²»ÊÇÒ»Ìõ
  ûÌõ¼Ç¼µÄ getintegral  RemainIntegral
µÄÖµ ÈçÉÏÃæÎÒËù˵µÄ

SQL code:
with t
as
(
select 16 a from dual
union all
select 18 from dual
union all
select 19 from dual
)
select a, sum(a)over(partition by 1 order by a) b from t

---

with t
as
(
select 16 a from dual
union all
select 18 from dual
union all
select 19 from dual
)
select a, sum(a)over(partition by 1 order by a) b from t


--Ö±½ÓÔËÐÐ,½á¹ûÈçÏÂ:
16 16
18 34
19 53