how to display month sales grand total in column for this query

select CONCAT(month(date),'-',YEAR(DATE)) as month, branch ,sum(total) as total
from BRANCH_SALES
where  DATE  between '20220101' and '20220131' and branch = '701'
group by CONCAT(month(date),'-',YEAR(DATE)),
Branch
ORDER BY total

what I'm looking for

CodePudding user response：

Just use a windowed SUM:

SUM(SUM(total)) OVER () AS GrandTotal

As the OVER clause doesn't have a PARTITION BY or ORDER BY clause, it'll give a SUM for the entire dataset.