Oracle 按时间段分组统计select dt, count(satisfy_degree) as num from T_DEMOi ,(select sysdate - (lev
Oracle 按时间段分组统计
select dt, count(satisfy_degree) as num from T_DEMO i ,(select sysdate - (level-1) * 2 dtfrom dual connect by level <= 10) dwhere i.satisfy_degree='satisfy_1' andi.insert_time<dt and i.insert_time> d.dt-2group by d.dt
例子中的sysdate - (level-1) * 2得到的是一个间隔是2天的时间 group by d.dt 也就是两天的时间间隔分组查询
