有查看相关资料说道,SQL SERVER 2008R2的数据库中不支持over partition by order by,有没有其他的方式解决这种问题
返回效果如下(以下为SQL SERVER 2012R2数据库中执行效果)
with test_data as (
select t.*
from (values ('1111', '202212', 100),
('1111', '202301', 200),
('1111', '202302', 50),
('1111', '202303', 150),
('1120', '202212', 10),
('1120', '202301', 20),
('1120', '202302', 30),
('1120', '202303', 30)
) t(id, dt, sales)
)
select id,dt,sum(sales) over (partition by x.id order by x.dt) as bal
from test_data x