Mysql总和和按分组方法 [英] Mysql Sum and Group By Method

问题描述

输入

日期    要点
           电子邮件

2012-07-01      5               [e-mail]

2012-07-01      6                [e-mail]

2012-07-01      2               [e-mail]

<2012-07-02      5&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; [e-mail]

2012-07-03      8&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; [e-mail]

2012-07-03      7
                [e-mail]

2012-07-03      1
                [e-mail]

2012-07-04      3&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; [e-mail]

2012-07-04      2&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; [e-mail]

2012-07-05      3&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; [e-mail]

2012-07-05      9&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; [e-mail]

输出

日期           要点

<2012> 2012-07-01      13

2012-07-02       5


2012-07-03      16元
2012-07-04       5


2012-07-05      12

建议我使用MySQL Query作为输出，如上所示

解决方案

$ sum $'$'$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $'

注意：不要忘记包装 date 列中`作为 DATE 是mySQL的保留关键字

Input

Date            Points            Email

2012-07-01       5                 [e-mail]
2012-07-01       6                [e-mail]
2012-07-01       2                 [e-mail]

2012-07-02       5                [e-mail]

2012-07-03       8                [e-mail]
2012-07-03       7                 [e-mail]
2012-07-03       1                 [e-mail]

2012-07-04       3                [e-mail]
2012-07-04       2                [e-mail]

2012-07-05       3                [e-mail]
2012-07-05       9                [e-mail]

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

解决方案

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

这篇关于Mysql总和和按分组方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！