Not sure how to go about this:-
I have a query
select name, city, salary from Employee
I can get a sum by doing a grouping
select name, city, sum(salary) total_salary from Employee group by name, city
How can I get the total per city as a separate row under each city ?
Expected Sample Result:
Name City Salary n1 c1 10 n2 c1 20 T1 c1 30 n3 c2 20 n4 c2 50 T2 c2 70