SELECT DATE_FORMAT( startDateTime, "%Y-%m-%d %H" ) AS date, COUNT(*) AS numFROM data_serviceGROUP BY date ORDER BY date;
按照每天每小时统计数量
End.
MYSQL 按时间 GROUP BY,布布扣,bubuko.com
MYSQL 按时间 GROUP BY
原文：http://www.cnblogs.com/lianche/p/3808197.html
