DB2 SQL实现小计总计汇总

最新推荐文章于 2022-02-08 16:27:36 发布

陈伦(colby)

最新推荐文章于 2022-02-08 16:27:36 发布

阅读量1k

点赞数

分类专栏： DB2 SQL

本文链接：https://blog.csdn.net/colby_chenlun/article/details/100123086

版权

SQL 同时被 2 个专栏收录

11 篇文章 1 订阅

订阅专栏

DB2

1 篇文章 0 订阅

订阅专栏

SELECT 
DECODE(ID,1,TO_CHAR(DATA_PRD,'YYYYMMDD'),2,TO_CHAR(DATA_PRD,'YYYYMMDD'),3,'总计') 调度日期
,DECODE(ID,1,JOB_STS ,2,'小计'  ,3,'-') 作业状态
,COUNT(1) 作业数 
FROM DWMM.JOB_LOG AS T1,
(select 1 as ID FROM SYSIBM.DUAL
        union 
        select 2 FROM SYSIBM.DUAL
        union 
        select 3 FROM SYSIBM.DUAL
) AS T2
GROUP BY DECODE(ID,1,TO_CHAR(DATA_PRD,'YYYYMMDD'),2,TO_CHAR(DATA_PRD,'YYYYMMDD'),3,'总计')
,DECODE(ID,1,JOB_STS,2,'小计',3,'-')