Mysql查询某段时间内每一天数据的汇总

Question

如题，例如我想要查询2016-04-20到2016-08-30期间 每一天的数据合
time num
2016-04-20 10
2016-04-20 20
2016-04-21 5
2016-04-21 6
. .
. .
. .
2016-08-30 30

查询出来就是
2016-04-20 30
2016-04-21 11
. .
. .
. .
2016-08-30 30

Answer 1

select time,sum(num) from table where time between startTme and endTime group by time ;