How to write a query to get cumulative spending?
Question
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways
Answers ( 2 )
select product_id, sum(spend) over (partition by product_id, user_id order by product_id) as Comm_Spend from table;
Ꮋello i am kavin, its my first time to commenting anyplace, when i read this post i thought i
could also make comment due to this good post.