How to sum row total???

Question

Hi. I know how to sum column total. Just add up each column. But I don't know how to calculate the total of rows, can someone guide me? Thanks.

Answer 1

Hi @00529562
You can take a look at this simple example.

create table test(id int,col1 int,col2 int,col3 int);
insert into test values
(1,1,1,1),(2,2,5,3),(3,1,6,7);

select id,sum(col1) as col1,sum(col2) as col2,sum(col3) as col3 
from test group by grouping sets(id,());

Output:

If you still have questions, you need to provide a datasheet so that we can help you further.