SELECT DATE_FORMAT( startDateTime, "%Y-%m-%d %H" ) AS date, COUNT(*) AS num
FROM data_service
GROUP BY date ORDER BY date;
按照每天每小时统计数量
End.
SELECT DATE_FORMAT( startDateTime, "%Y-%m-%d %H" ) AS date, COUNT(*) AS num
FROM data_service
GROUP BY date ORDER BY date;
按照每天每小时统计数量
End.
转载于:https://www.cnblogs.com/lianche/p/3808197.html