Skip to content
Advertisement

Sum some columns order by ID in SQL [closed]

I’m trying to sum some columns by id. But I’m retrieving 1 raw.

For Example

Id      | C1| C2| 
---------------------------------
1       | 2  | 1  | 
2       | 5  | 4  | 
3       | 3  | 1  | 
4       | 5  | 2  | 

Result that ı trying to get:

Id      |Total
---------------------------------
1       | 3  |
2       | 9  | 
3       | 4  | 
4       | 7  | 

How I can do this?

Advertisement

Answer

You just need addition operation + as follows:

select id, c1+c2 as total 
  from your_table
User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement