MySQL 在单个查询中按总和和总和进行分组

Getting group by sum and total sum in a single query

提问by

Is there any way to get total price of all products by category and total price of all products in a single query.

有没有办法在单个查询中按类别获取所有产品的总价和所有产品的总价。

Below is query i am using giving price by category.

下面是我正在使用按类别给出价格的查询。

SELECT SUM(price) as totalprice
FROM products 
Group BY category_id

回答by

use ROLLUPwith your query.

将ROLLUP用于您的查询。

The GROUP BY clause permits a WITH ROLLUPmodifier that causes extra rows to be added to the summary output.

GROUP BY 子句允许使用 WITHROLLUP修饰符导致将额外的行添加到摘要输出中。

SELECT category_id,SUM(price) as totalprice
FROM products 
GROUP BY category_id WITH ROLLUP

回答by nnichols

SELECT category_id, SUM(price) as totalprice
FROM products 
GROUP BY category_id WITH ROLLUP

Check out the page in the manual

查看手册中的页面