求大神看看，为什么报invalid relational operator错误

阳台的小熊--

于 2022-09-09 10:16:53 发布

阅读量1.1k

点赞数 1

文章标签： java 数据库 sql

本文链接：https://blog.youkuaiyun.com/Burning_me_/article/details/126777554

版权

该博客讨论了一种SQL查询方法，通过结合日期和时间处理，将数据按小时进行分组并计数。查询涉及到右连接操作，使用NVL函数处理空值，并通过序列生成时间序列数据。内容涵盖了数据库查询技巧和时间序列分析的基础应用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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