按2小时段统计
select * from (SELECT FLOOR(HOUR(dateTimeColumn) / 2) * 2 as hour, count(id) as num FROM tableName group by hour ) tmp order by num
按1小时段统计
select * from (SELECT HOUR(dateTimeColumn) as hour, count(id) as num FROM tableName group by hour ) tmp order by num
李小家
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。