店铺 月份 销量
a 1 10
a 2 20
a 3 30
b 1 20
b 2 30
a 4 50
c 1 20
c 2 40
店铺 月份 销量 该月之前的累计销量
a 1 10 10
a 2 20 30
a 3 30 60
a 4 50 110
b 1 20 20
b 2 30 50
c 1 20 20
c 2 40 60
c 3 50 110
select id,month,max(t1.sell_num),sum(sell_num)
from
(select
id,month,sell_num,row_number() over(partition by id order by month asc) as t_left
from default.sell_detail
) t1
left join
(select
id,month,sell_num,row_number() over(partition by id order by month asc) as t_right
from default.sell_detail
) t2
on t1.id = t2.id
where t1.left >= t1.right
group by id,month
order by id,month
select
id,month,sell_num,sum(sell_num) over(partition by id order by month rows between unbounded preceding and current row)
from default.sell_detail
