计算合计行和汇总结果

一、orcal中通过ROLLUP-同时得出合计和小计

mysql> select product_type,SUM(sale_price) as sum_price from product GROUP BY ROLLUP(product_type);

二、mysql中

mysql> select product_type,SUM(sale_price) as sum_price from product GROUP BY product_type with ROLLUP;

三、在GROUP BY 中添加”登记日期“（使用ROLLUP）

1.在orcal中

2.在mysql中

mysql> select product_type,regist_date,sum(sale_price) as sum_price from product group by product_type,regist_date with ROLLUP;