你先保证你查询出的结果集包括2月份的记录,分组就没有问题了. 这就涉及到外关联一个月份表的技术了,假如t2是个月份表(包含12个月)select to_char(t1.rq,'yyyy-mm') from t1,t2 where to_char(t1.rq,'yyyy-mm') (+)= to_char(t2.rq,'yyyy-mm')
select tt.coldate, nvl(tt.snum,0) from (select rownum id from all_source where rownum<12) t, (select coldate,sum(num) snum from tbname group by coldate) tt where t.id=to_char(coldate,'mm')(+);
select tt.coldate, nvl(tt.snum,0) from (select rownum id from all_source where rownum<=12) t, (select coldate,sum(num) snum from tbname group by coldate) tt where t.id=to_char(coldate,'mm')(+);
bzszp 呢??? 昨天好像也是你帮我的??? 你信誉超过100,怎么超过去的??
知道你的意思 晕~ 你吧 select coldate,sum(num) snum from tbname group by coldate 换成你的语句就行了
这就涉及到外关联一个月份表的技术了,假如t2是个月份表(包含12个月)select to_char(t1.rq,'yyyy-mm')
from t1,t2
where to_char(t1.rq,'yyyy-mm') (+)= to_char(t2.rq,'yyyy-mm')
(select rownum id from all_source where rownum<12) t,
(select coldate,sum(num) snum from tbname group by coldate) tt
where t.id=to_char(coldate,'mm')(+);
(select rownum id from all_source where rownum<=12) t,
(select coldate,sum(num) snum from tbname group by coldate) tt
where t.id=to_char(coldate,'mm')(+);
你信誉超过100,怎么超过去的??
你吧
select coldate,sum(num) snum from tbname group by coldate
换成你的语句就行了