select scrq,rsj,
sum(rsj) over(order by scrq) as nsj
from tb_test_over order by scrq;
使用OVER 结合 PARTITION BY 对每月进行累加;
select scrq,rsj,sum(rsj)
over(partition by to_char(scrq,'yyyy-mm') order by scrq) ysj
from tb_test_over
order by scrq;
综合版,查询日、月、年累加数据;
select scrq,rsj,
sum(rsj) over(partition by to_char(scrq,'yyyy-mm') order by scrq) ysj,
sum(rsj) over(order by scrq) as nsj
from tb_test_over
order by scrq;
动态追加日累计、月累计:select * from tb_test_over ;使用OVER函数动态追加列,根据SCRQ对RSJ累计求和select scrq,rsj,sum(rsj) over(order by scrq) as nsj from tb_test_over order by scrq;使用OVER 结合 PARTITION BY 对每月进行累加; select scrq,rsj,sum(rsj) over(partition by to_cha.