How I can sum elements of a column in SQL?

Question

I have a table with 4 columns (W,X,Y,Z). I want to select some rows from the table and then MySQL to return a single row having the values added on each column...

 

   W X Y Z

1. 2 2 2 2

2. 4 4 4 4

3. 6 7 8 9

MySql should return in this case, if I select all the four rows:

 

   W   X   Y  Z

1. 12  13 14  15

Answer 1

I can sum elements of a column in SQL. Using this code you will get your solutions.

select sum(W),sum(X),sum(Y),sum(Z) from mytable where id in (1,2,3,4);