MySQL SUM only 1 field and

Question

I have the following table structure

--ID-- --Date-- --Value--
  1    2013-1-2     23
  2    2013-1-2     11
  3    2013-1-3     8
  4    2013-1-3     7

As you can see the dates can overlap and I want to output every different date with a summation of the values attributed. So for this it would be.

--Date--   --Total-- 
2013-1-2      34 
2013-1-3      15

Is this even possible with a query or will I have to do some seperate summation?

letiagoalves · Accepted Answer · 2013-03-18 21:41:59Z

1

SELECT Date, sum(Value) as Total
FROM Table
GROUP BY Date

answered Mar 18, 2013 at 21:41

letiagoalves

11.3k4 gold badges42 silver badges68 bronze badges

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

1 Answer 1