题解 | 计算每日累计利润
计算每日累计利润
https://www.nowcoder.com/practice/c9b7a2f73eb54a3da4a81f15fd8a3665
SELECT x.profit_id,x.profit_date,x.profit,(select sum(y.profit)
from daily_profits y
where y.profit_id<=x.profit_id) cumulative_profit
FROM daily_profits x
order by profit_date;
查看12道真题和解析