postgresql - How to write a sql query to sum total for each day? -

Please help me write the following SQL I have a table with an amount column and date column

  date of the date ----------------------- 100 - 2010-02-05 200 - 2010-02-05 50 - 2010-02-06 10 - 2010-02-06 10 2010-02-07  

What do I want to write Get a SQL total for each day. Finally, my query should return something like this

  date of the date ----------------- 300 - 2010-02-05 60 - 2010- 02 - 06 10 - 2010-02-07  

Please note that now it has been expressed for the date of the group based on date and amount.

Resoluted -

It was my bad, even though I mentioned the date date here, my actual date column 'timestamp' was in the PostGrase table.

My working SQL is like this from the amount of the amount (amount), date (date) from the bill group to date (date) "

.

Thanks everyone (and I I will accept the answer as the correct answer because I can only accept one answer)

thanks again

Xara

< Div class = "post-text" itemprop = "text">

Beautiful basic statement by group

  SELECT SUM (table.amount)), Table Table.date