一、WITH ROLLUP函数适用于跟在GROUP BY 字段后面进行分组求和使用
SELECT t1.`产品名称`,SUM(t1.`数量`),SUM(t1.`金额`),t1.`日期` FROM sheet2 t1 GROUP BY t1.`产品名称`,t1.`日期` WITH ROLLUP;
一、WITH ROLLUP函数适用于跟在GROUP BY 字段后面进行分组求和使用
SELECT t1.`产品名称`,SUM(t1.`数量`),SUM(t1.`金额`),t1.`日期` FROM sheet2 t1 GROUP BY t1.`产品名称`,t1.`日期` WITH ROLLUP;