mysql 根据时间里的小时来分组

例子：

SELECT HOUR(column_name) AS hour, COUNT(*) AS count
FROM table_name
GROUP BY HOUR(column_name)

 

posted @ 2023-11-20 11:41  浅笑19  阅读(10)  评论(0)  编辑  收藏  举报