group by + sumで集計した結果を、さらに総和を求めるには？？

Question

この結果の総和を算出するにはどう記述するのですか？？

select * from
(
	select corporation_staff_id, sum(commission_money) from corporation_staff_salaries where corporation_id = 2 
	and year(date) = '2020' and 
	month(date) = '2' and 
	deleted_at is null 
	group by corporation_staff_id
) AS sum_data;

Answer 1

むしろ総和だけならこれで取れますね。

select sum(commission_money)
from corporation_staff_salaries
where corporation_id = 2 and
　　　 year(date) = '2020' and 
  　  month(date) = '2' and 
    　deleted_at is null 

Answer 2

総和だけ欲しければこれでダメでしたっけ？

select sum(m) from
(
    select corporation_staff_id,
      sum(commission_money) as m -- 別名を忘れずに
    from corporation_staff_salaries where corporation_id = 2 
    and year(date) = '2020' and 
    month(date) = '2' and 
    deleted_at is null 
    group by corporation_staff_id
) AS sum_data;

Answer 3

MySQL :: MySQL 5.6 リファレンスマニュアル :: 12.19.2 GROUP BY 修飾子

にある、with rollupで処理します。

Comments

[yambejp]

サンプルデータを提示いただければ、具体的な書き方も返答できると思います

Answer 4

参考に