题解 | 计算每日累计利润
计算每日累计利润
https://www.nowcoder.com/practice/c9b7a2f73eb54a3da4a81f15fd8a3665
select x.profit_id, x.profit_date, x.profit, sum(y.profit) cumulative_profit from daily_profits x, daily_profits y where x.profit_date >= y.profit_date group by x.profit_id, x.profit_date, x.profit order by x.profit_date asc
双表查询
海康威视公司福利 1272人发布

查看19道真题和解析