pl/sql 取小时

 

count, where

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子句限定日期