mysql - Getting group by sum and total sum in a single query

Question

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

Answer 1

use ROLLUP with your query.

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

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