oracle查询结果展示,ORACLE构造查询日期展示结果

最新推荐文章于 2023-09-07 16:30:08 发布

weixin_39930276

最新推荐文章于 2023-09-07 16:30:08 发布

阅读量161

点赞数

文章标签： oracle查询结果展示

这个博客内容涉及SQL查询技术，用于展示特定月份每日及总计的数据。查询示例针对当前月份，通过UNION ALL连接多个日期，筛选出当前月的每一天，并在最后显示合计数。查询结果包含每天的订单数量（order_no）。

摘要由CSDN通过智能技术生成

需求：要求安装月份查询结果展示每天和总合计的数据，如果在当前月份查询只展示当月当前今天的数据。

例如：当前是3月份查询构造时间如下：

select c stat_day,1 order_no from(

select '201703'||'01' c from dual union all select '201703'||'02' c from dual union all select '201703'||'03' c from dual union all

select '201703'||'04' c from dual union all select '201703'||'05' c from dual union all select '201703'||'06' c from dual union all

select '201703'||'07' c from dual union all select '201703'||'08' c from dual union all select '201703'||'09' c from dual union all

select '201703'||'10' c from dual union all select '201703'||'11' c from dual union all select '201703'||'12' c from dual union all

select '201703'||'13' c from dual union all select '201703'||'14' c from dual union all select '201703'||'15' c from dual union all

select '201703'||'16' c from dual union all select '201703'||'17' c from dual union all select '201703'||'18' c from dual union all

select '201703'||'19' c from dual union all select '201703'||'20' c from dual union all select '201703'||'21' c from dual union all

select '201703'||'22' c from dual union all select '201703'||'23' c from dual union all select '201703'||'24' c from dual union all

select '201703'||'25' c from dual union all select '201703'||'26' c from dual union all select '201703'||'27' c from dual union all

select '201703'||'28' c from dual union all select '201703'||'29' c from dual union all select '201703'||'30' c from dual union all

select '201703'||'31' c from dual)

where c and c union all

select '合计' stat_day,0 order_no from dual;

说明：使用小于当前时间筛选当月的日期、使用c

关注