复杂SQL收集

以当前时间往前每5分钟统计一次 sql

select To_Char(d.name, 'hh24:mi') name, count(DATANAME) as count  from DATARECORD_PROXY i RIGHT join (select sysdate-((1/24)/12)*(level-1) name from dual  connect by level <= 10) d  ON i.CREATEDATA < d.name and i.CREATEDATA> (d.name-((1/24)/12)) group by d.name,i.DATANAME ORDER BY d.name ASC
1