select sum in sql server using one query

Question

I have a table in my database with two columns as int for example cal1 and cal2.

I make the sum from each row as in select ( cal1 + cal2) from cat as total, now I want to do the sum from all columns total if is possible.

Vincent Savard · Accepted Answer · 2011-07-31 17:56:01Z

2

You can do the addition in the SUM :

SELECT SUM(cal1+cal2) AS total
  FROM cat

answered Jul 31, 2011 at 17:56

Vincent Savard

36.1k10 gold badges71 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

@naf-naf: are you sure this does what you want? I thought you wanted per row and the SUM of all rows in one go?

@naf-naf: who was that last comment for? Use the @ thing if me please. See my answer too

gbn, this does exactly what you describe. Edit: Sorry, I misunderstood your post (realized this after seeing your answer). You are probably right.

Jacob · Accepted Answer · 2011-07-31 17:52:14Z

0

SELECT (SUM(cal1) + SUM(cal2)) AS TotalSum FROM cat

Thats to sum the values of all rows together. If you want to sum all columns up, you have to specifically write their names into the column list.

answered Jul 31, 2011 at 17:52

Jacob

43.6k6 gold badges81 silver badges81 bronze badges

I need to know each row alone, and also the all rows from the to collumns, With this example it does not work

gbn · Accepted Answer · 2011-07-31 18:26:13Z

0

You want 2 totals in one go?

SELECT
   cal1+cal2 AS PerRowTotal,
   SUM(cal1+cal2) OVER () AS AllRowTotal
FROM
   cat

answered Jul 31, 2011 at 18:26

gbn

434k84 gold badges602 silver badges689 bronze badges