How to generate grand total for the total column as a separate result in SQL server?

A COMPUTE BY clause allows you to see both detail and summary rows with one SELECT statement. You can calculate summary values for subgroups, or a summary value for the whole result set.

Example:
SELECT department_id, COUNT(*) as Total
FROM employees
GROUP BY department_id
compute sum(count(*))