17,377
社区成员
发帖
与我相关
我的任务
分享
select nvl(sum(synnum),0) value ,to_char(syntime, 'yyyy-MM-dd') lable from synlog where syntype in (4, 5, 6) and trunc(syntime) > trunc(sysdate) - 30 group by to_char(syntime, 'yyyy-MM-dd') ;
with t1 as(
select level as id, to_date('2017-12-19','yyyy-mm-dd')+2 - level as date1 from dual
connect by level<6)
,t2(value,lable) as(
SELECT 1 AS "value", trunc(sysdate)as lable from dual
union all
SELECT 9 AS "value", trunc(sysdate-4)as lable from dual)
select t1.date1, NVL(t2.value,0) AS value1 from t1 left join t2 on t1.date1=t2.lable ORDER BY DATE1
/*
DATE1 VALUE1
1 2017/12/16 9
2 2017/12/17 0
3 2017/12/18 0
4 2017/12/19 0
5 2017/12/20 1
*/
把 T2里面的改成你的查询就可以