select cast((b.title || 0) as char) as name, nvl(total,0) value from(
select substr(to_char(wfsj,'yyyy-MM-dd hh24'),12,2) title,count(1)
total from jgxt_jtwfcfxxb
group by substr(to_char(wfsj,'yyyy-MM-dd hh24'),12,2)) a
right join ( 这里是序列
select substr(to_date(sysdate, 'yyyy-MM-dd')-seq_hour/24 ,12, 2)
as title
from(
select a from
(select '1' as a from dual union select '2' from dual
union select '3' from dual
union select '4' from dual ) a
join (select '1' from dual union select '2' from dual
union select '2' from dual union select '3' from dual
union select '4' from dual union select '5' from dual
union select '6' from dual) b
on 1 ) as b, (select -1 as i from dual) ) b
on a.title = b.title
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交