How to aggregate Postgres table rows

Question

I have a table constructed like this :

Date  | Account  | Total
1     | A        | 1000
3     | A        | 1000
4     | A        | 200
5     | A        | 3000
2     | B        | 100
3     | B        | 2000
4     | C        | 500

I'd like to query this table to get a result like this :

Date  | Total
1     | 1000
2     | 100
3     | 3000
4     | 700
5     | 3000

Basically, I don't care about the account but want to sum the total per date

I've been going around in circles trying to do this super simpple task! Can someone please help me? hanks! Thank you very much.

Josh Kupershmidt · Accepted Answer · 2016-06-20 16:24:30Z

2

You are looking for GROUP BY with an aggregate function: SUM. Something like:

SELECT date, SUM(total)
FROM your_table_name
GROUP BY date
ORDER BY date;

answered Jun 20, 2016 at 16:24

Josh Kupershmidt

2,7561 gold badge26 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

How to aggregate Postgres table rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related