sum of column in sql server

Question

I have an employee table in which there is a column of salary name. Now I want the sum of the salary column in the last row but the total should be written in the row next to it as per the photo below where null is written.

select emp_name,SUM(emp_salary) as salary 
from   employe 
group by emp_name WITH ROLLUP 
order by emp_name desc

And the table format looks the same with the employee name

Answer 1

You can use COALESCE:

coalesce(emp_name,'Total') as emp_name

In your query:

select coalesce(emp_name,'Total') as emp_name,
       SUM(emp_salary) as salary 
  from employe 
group by emp_name WITH ROLLUP 
order by emp_name desc