题解 | 计算每日累计利润
计算每日累计利润
https://www.nowcoder.com/practice/c9b7a2f73eb54a3da4a81f15fd8a3665
select profit_id,profit_date,profit, sum(profit) over (order by profit_date) cumulative_profit from daily_profits
窗口函数
function_name([参数]) OVER( [PARTITION BY 分组列] [ORDER BY 排序列] [ROWS/RANGE 窗口范围] )
投递字节跳动等公司7个岗位