oracle 用over进行累计计算

最新推荐文章于 2023-02-09 18:43:05 发布

宅男当道

最新推荐文章于 2023-02-09 18:43:05 发布

阅读量2.2k

点赞数

分类专栏：数据库文章标签： oracle sql

本文链接：https://blog.csdn.net/awe5566/article/details/18734797

版权

数据库专栏收录该内容

1 篇文章 0 订阅

订阅专栏

create or replace view sumproinvview
(guid, proguid, prono, proname, proclass, process, auditmoney, year, month, moninv, suminv, sumpercent)
as
select guid,proguid,prono,proname,proclass,process,auditmoney,year,month,sumInv,
       sum(sumInv) over(partition by proguid order by month),  sum(sumPercent) over(partition by proguid order by month)
from proInvview pd;

以上sql 可根据月份来进行分月统计，即截止到该月为止的总数目