Question

sql如何根据时间进行分类计算总数

表tab中有字段aa，time如下：

11 2014-04-06 20:00:00
12 2014-04-07 20:00:00
13 2014-04-06 21:00:00
11 2014-04-08 20:00:00
11 2014-04-09 20:00:00
如何select分类为time，总数两列
2014-04-06 2
2014-04-07 1
2014-04-08 1

Answer 1

SELECT CAST(time as DATE) AS time,COUNT(*) AS 总数
FROM tab
GROUP BY CAST(time as DATE)