SQL 查询：获取每月累计销售额

• 日期: 2026-05-14
• 标签: 常规

SELECT DATE_FORMAT(order_date, '%Y-%m') AS month, SUM(total_amount) AS cumulative_sales FROM orders GROUP BY DATE_FORMAT(order_date, '%Y-%m') ORDER BY month ASC;

原文地址: https://www.cveoy.top/t/topic/npNm 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录