How do I add a total as the last row in my sql?

mysql, sql, sql-server

Solution

Use the `WITH ROLLUP` modifier to `GROUP BY`:

SELECT   IFNULL(env, 'Unknown'),
         COUNT(*) AS Count
FROM     env_table
GROUP BY env WITH ROLLUP
ORDER BY env

Problem

I'm trying to display a row, 'Total', that will do a sum of the Count column. The following code will have two columns, Environment and Count. ``` select case when env is null THEN 'Unknown' else env end, count(*) as Count from env_table group by env order by env / ``` Output I would like: Windows 200 Linux 120 Total 320 As you can see above, what I would like to do is add a row called "Total" at the end that would essentially do a SUM(count(*)). What is the proper syntax to do this? Thanks!

Original source