题解 | 计算每日累计利润
计算每日累计利润
https://www.nowcoder.com/practice/c9b7a2f73eb54a3da4a81f15fd8a3665
SELECT profit_id,profit_date,profit, SUM(profit)OVER(ORDER BY profit_date) AS cumulative_profit FROM daily_profits ORDER BY profit_date;
计算每日累计利润
https://www.nowcoder.com/practice/c9b7a2f73eb54a3da4a81f15fd8a3665
SELECT profit_id,profit_date,profit, SUM(profit)OVER(ORDER BY profit_date) AS cumulative_profit FROM daily_profits ORDER BY profit_date;
相关推荐