MYSQL 按时间 GROUP BY
时间:2022-03-10 17:45
SELECT DATE_FORMAT( startDateTime, "%Y-%m-%d %H" ) AS date, COUNT(*) AS num
FROM data_service
GROUP BY date ORDER BY date;
按照每天每小时统计数量
End.
MYSQL 按时间 GROUP BY,布布扣,bubuko.com
时间:2022-03-10 17:45
SELECT DATE_FORMAT( startDateTime, "%Y-%m-%d %H" ) AS date, COUNT(*) AS num
FROM data_service
GROUP BY date ORDER BY date;
按照每天每小时统计数量
End.
MYSQL 按时间 GROUP BY,布布扣,bubuko.com