and to_char(kpi.PERIOD_START_TIME,'hh24') >= '13' and to_char(kpi.PERIOD_START_TIME,'hh24') = '19' and to_char(kpi.PERIOD_START_TIME,'hh24') = '19' and to_char(kpi.PERIOD_START_TIME,'hh24') = '2' and to_char(kpi.PERIOD_START_TIME,'hh24') ) ,count(*) from as s group by DATEPART ( hour,) ; --------考虑IP重复问题----------- select hournum,count(*) from (select DATEPART ( hour,) as hournum, from ) group by hournum 假若还要考虑某一天,那便加上where子句限定日期 |
pl/sql 取小时
最新推荐文章于 2024-07-26 22:40:29 发布