Mysql Sum and Group By Method

Question

Input

Date Points Email

2012-07-01       5                 [email protected]
2012-07-01       6                [email protected]
2012-07-01       2                 [email protected]

2012-07-03       8                [email protected]
2012-07-03       7                 [email protected]
2012-07-03       1                 [email protected]

Output

Date Points

2012-07-01       13
2012-07-02        5
2012-07-03       16
2012-07-04        5
2012-07-05       12

Suggest me an MySQL Query for output like the above

xkeshav · Accepted Answer · 2012-07-11 04:19:38Z

3

try

 SELECT `date`, SUM(`Points`) AS sumPoint FROM table GROUP BY `date`

Note : dont forget to wrap date column with ` as DATE is reserve keyword of mySQL

answered Jul 11, 2012 at 4:19

xkeshav

54.2k47 gold badges183 silver badges255 bronze badges

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

Comments

aprilleocean · Accepted Answer · 2012-07-11 04:43:31Z

0

SELECT date, SUM(Points) AS sumPoint FROM table GROUP BY DATE(date)

Since date column might be datetime or date type in table

answered Jul 11, 2012 at 4:43

aprilleocean

12110 bronze badges