Is it possible to select * where then add all results?

Question

I have a sql table with a user_id and an integer

Is it possible to select integer from table where user_id = ? then add all integer results together and return just the one integer result?

To amplify: "select user_id, sum(integer_value) from my_table group by user_id;" — T Gray, Oct 20 '16 at 19:20
@JuanCarlosOropeza - Thanks. My query was predicated on not-having-read-the-whole-statement. My comment was more along the lines of "teach" vs "go look it up." — T Gray, Oct 20 '16 at 19:28
Dupe close: In your case it would be for a single user. Same question. — Drew, Oct 20 '16 at 19:33

score 2 · Answer 1 · answered Oct 20 '16 at 19:20

2

yes - try something along of the lines of:

SELECT SUM(integer) FROM tbl WHERE user_id = 'xxx'

answered Oct 20 '16 at 19:20

Tom

score 2 · Accepted Answer · answered Oct 20 '16 at 19:20

2

You could do something like

SELECT sum(integer) As ReturnValue
FROM table
WHERE user_id = [value]

answered Oct 20 '16 at 19:20

Michael Armes

2 Answers2