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; 通过子查询来实现