select count(*),t.分组字段 from (select t.* ,to_char(t.时间,'hh24') stime,to_char(t.时间,'hh24mi') fz,to_char(时间,'d') from a twhere 时间>=to_date('2019-12-01','yyyy-mm-dd') and...
oracle 取某个时间段的数据,具体代码如下所示:
select count(*),t.分组字段 from (
select t.* ,to_char(t.时间,'hh24') stime,to_char(t.时间,'hh24mi') fz,to_char(时间,'d')
from a t
where 时间>=to_d...