CODEWITHSUNDEEP
sqlpostgresql
samir
samir

Reputation: 11

How to sum values in a column based on values in a different column SQL

For example, lets say I have

id values
1 10
1 12
1 10
2 2
2 5
2 4

then i would want sql to return

id values
1 32
2 11

Upvotes: 0

Views: 113

Answers (2)

Anand Rajakrishnan
Anand Rajakrishnan

Reputation: 148

Select ID,sum(values) From table Group by ID;

Upvotes: 0

ysth
ysth

Reputation: 98388

This is very basic sql.

select id, sum(values) as values
from foo
group by id

Upvotes: 1

Related Questions