题解 | 计算每日累计利润
计算每日累计利润
https://www.nowcoder.com/practice/c9b7a2f73eb54a3da4a81f15fd8a3665
SELECT
a.profit_id,
a.profit_date,
a.profit,
(
SELECT
SUM(b.profit)
FROM
daily_profits b
WHERE
b.profit_date <= a.profit_date
) AS cumulative_profit
FROM
daily_profits a
ORDER BY
a.profit_date ASC;
通过子查询来实现
查看13道真题和解析