select sum(SHOW_NUMBER) as SHOW_NUMBER ,d.dt
from T_RECOMMEND_ANALYSIS t,(
select to_date('2018-06-08','yyyy-MM-dd') - (level-1) * 7 dt
from dual connect by level <=15) d
where t.CREATE_TIME<dt and t.CREATE_TIME> d.dt-7
group by d.dt
按照时间7天进行分组
select sum(SHOW_NUMBER) as SHOW_NUMBER ,d.dt
from T_RECOMMEND_ANALYSIS t,(
select to_date('2018-06-08','yyyy-MM-dd') - (level-1) * 7 dt
from dual connect by level <=15) d
where t.CREATE_TIME<dt and t.CREATE_TIME> d.dt-7
group by d.dt
按照时间7天进行分组