1、查询一段时间内的一些相关统计
select to_char(d.rdate,'dd-MM-yyyy') rdate,decode(cnum,null,0,cnum) cnum,decode(fnum,null,0,fnum) fnum FROM (
count(decode(tlist.status,6,tlist.status,null)) fnum from a_work_order tlist
) c on c.create_date=to_char(d.rdate,'dd-MM-yyyy') order by d.rdate
select to_char(d.rdate,'dd-MM-yyyy') rdate,decode(cnum,null,0,cnum) cnum,decode(fnum,null,0,fnum) fnum FROM (
select to_date('24-09-2016','dd-MM-yyyy')+ (rownum - 1) rdate from
dual connect by rownum <= (to_date('28-11-2016','dd-MM-yyyy') - to_date('24-09-2016','dd-MM-yyyy') + 1)
) d left join (
select to_char(tlist.create_date,'dd-MM-yyyy') create_date,count(tlist.team_id) cnum,count(decode(tlist.status,6,tlist.status,null)) fnum from a_work_order tlist
) c on c.create_date=to_char(d.rdate,'dd-MM-yyyy') order by d.rdate