题解 | 计算每日累计利润
计算每日累计利润
https://www.nowcoder.com/practice/c9b7a2f73eb54a3da4a81f15fd8a3665
select
profit_id,
profit_date,
profit,
sum(profit) over(rows between unbounded preceding and current row) as cumulative_profit
from daily_profits;
计算每日累计利润
https://www.nowcoder.com/practice/c9b7a2f73eb54a3da4a81f15fd8a3665
select
profit_id,
profit_date,
profit,
sum(profit) over(rows between unbounded preceding and current row) as cumulative_profit
from daily_profits;
相关推荐