一些统计sql
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 easypay.表名称 WHERE (UPDATE_TIME >= to_date('2021-10-14', 'yyyy-mm-dd') a
原创
2021-11-29 16:51:04 ·
657 阅读 ·
0 评论