I have a query that sums categories. But I would like a sum of all those numbers as the last row.
SELECT sum(dead) AS ['dead'], incidents.category AS ['Category']
FROM incidents
GROUP BY incidents.category;
There has to be a way to get a total of all those sums that does not require a separate query.
Nope. You could ADD a field that sums each row cumulatively though.
ReplyDelete