SUM specific set of values in SQL

Question

I've been trying to look for a way to sum a specific set of values in a query.

Currently I have a query that returns all values needed, but I want it to now sum several values.

 |Name|Value|
 |x   |1    |
 |x   |2    |
 |x   |3    |
 |x   |5    |
 |y   |3    |
 |y   |2    |
 |y   |2    |
 |y   |3    |
 |z   |3    |
 |z   |2    |
 |z   |1    |

I don't know if I should run a subquery, I'm not necessarily summing up distinct values, but instead have something along the lines of this:

|Name|Value|
|x   |11   |
|y   |10   |
|z   |6    |

Although, each entry has their own unique ID for their respective row. I'm fairly new at this so I don't know if I would take that into account with my query.

why can't you just do a select sum(Value) ... group by Name? — Marc B
– Marc B, Commented Feb 29, 2016 at 16:47
There is a lot more to my select statement, there are more than two columns, a join, a date range, and an order by. I wanted to see how the sum works and build upon that in my query. — walangala
– walangala, Commented Feb 29, 2016 at 16:52
then you should put that into your question. we can't read your mind, after all... — Marc B
– Marc B, Commented Feb 29, 2016 at 17:00

paparazzo · Accepted Answer · 2016-02-29 17:17:10Z

1

Select q.name, sum(q.value) 
from (YOUR_SELECT_QUERY) q
group by q.name

edited Feb 29, 2016 at 17:17

paparazzo

45.2k24 gold badges110 silver badges180 bronze badges

answered Feb 29, 2016 at 16:51

Simon Ludwig

1,8341 gold badge23 silver badges30 bronze badges

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

Comments

chancrovsky · Accepted Answer · 2016-02-29 18:04:11Z

0

A CTE might be the easiest way to go here:

;WITH CTE AS (Your Query Here)

SELECT Name, SUM(Value) AS Value
FROM CTE
GROUP BY Name

edited Feb 29, 2016 at 18:04

chancrovsky

5803 silver badges11 bronze badges

answered Feb 29, 2016 at 17:06

APH

4,1541 gold badge28 silver badges37 bronze badges

Collectives™ on Stack Overflow

SUM specific set of values in SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related