SELECT to_char(date_cr, 'yyyy-mm-dd : HH24') AS create_time, COUNT(date_cr) AS counts
FROM t_task
WHERE date_cr > '2022-03-17 00:00:00'
GROUP BY create_time
ORDER BY create_time DESC;
sql实现按小时统计查询
最新推荐文章于 2024-05-09 16:44:46 发布
SELECT to_char(date_cr, 'yyyy-mm-dd : HH24') AS create_time, COUNT(date_cr) AS counts
FROM t_task
WHERE date_cr > '2022-03-17 00:00:00'
GROUP BY create_time
ORDER BY create_time DESC;