Sql query to find out sum against individual id

Question

Suppose I have table like:

name: table_money

I need a sql query that produces the following result containing sum of money for each id.

How can I find out the total money of an individual id?

What is the SQL query?

Check out `GROUP BY`, combined with `SUM`. – jarlh Feb 24 '16 at 16:04 — jarlh, Feb 24 '16 at 16:04
select id,sum(money) from table_money group by id – sagi Feb 24 '16 at 16:09 — sagi, Feb 24 '16 at 16:09

score 2 · Accepted Answer · edited May 23 '17 at 10:30

To get the sum for each ID you need to group the results by the id column and apply the SUM aggregate function to the money column.

SELECT id, SUM(money) 
FROM table_money
GROUP BY id

You can read more about grouping of SQL results here:

Group by two columns and display grand total in every row

Having Sums, Averages, and Other Grouped Data by Oracle Magazine

GROUP BY (Transact-SQL) on MSDN

Sql query to find out sum against individual id

1 Answers1

Linked