mysql - 如何根据日期计算日期范围内特定列中的所有值

Question

我有一张表，其中包含列:

ID| rect_id| vieweed_user_id| view_count|view_date
1 | 1      | 1              | 1         |2017-03-07 10:54:21
2 | 1      | 2              | 1         |2017-03-08 01:00:45
3 | 1      | 3              | 1         |2017-03-08 12:54:12

例如，我想根据 view_date 查找所有 view_count 值的计数

view_date  | view_count
2017-03-08 |    2
2017-03-07 |    1

但我的问题是我想查找指定日期范围内的所有计数 view_count 值，例如

from 2016-03-08 to 2017-03-08

Answer 1

试试这个。

SELECT view_date, sum(view_count) as total_count FROM TABLE_NAME WHERE view_date >= '2016-03-08' AND view_date <= '2017-03-08' group by view_date