Oracle 按着小时分组
select s.stat_date, s.data_num
from (select to_char(UPDATE_TIME, 'yyyy/mm/dd hh24') || '点' as stat_date,
count(1) as data_num
from 表名称
WHERE (UPDATE_TIME >= to_date('2021-10-14', 'yyyy-mm-dd') and
UPDATE_TIME < to_date('2021-10-15', 'yyyy-mm-dd'))
group by to_char(UPDATE_TIME, 'yyyy/mm/dd hh24') || '点') s