有表colog,时间字段为createtime,数据如这个样子。
num createtime
1 2013-11-22 11:27:10.000
2 2013-11-22 11:29:28.000
3 2013-11-22 11:08:56.000
4 2013-11-22 11:27:10.000
5 2013-11-22 11:29:28.000
6 2013-11-22 11:08:56.000
7 2013-11-22 11:27:10.000
8 2013-11-22 11:29:28.000
.
想以分钟来进行汇总成结果如下
num createtime count(1)
1 2013-11-22 11:27 3
2 2013-11-22 11:29 3
3 2013-11-22 11:08 2求大神指点语句应该如何来写
num createtime
1 2013-11-22 11:27:10.000
2 2013-11-22 11:29:28.000
3 2013-11-22 11:08:56.000
4 2013-11-22 11:27:10.000
5 2013-11-22 11:29:28.000
6 2013-11-22 11:08:56.000
7 2013-11-22 11:27:10.000
8 2013-11-22 11:29:28.000
.
想以分钟来进行汇总成结果如下
num createtime count(1)
1 2013-11-22 11:27 3
2 2013-11-22 11:29 3
3 2013-11-22 11:08 2求大神指点语句应该如何来写
from colog group by CONVERT(char(16),createtime,120) order by 1
from colog
group by CONVERT(char(16),createtime,120)
order by num