ORACLE 统计前三十天每天的数据量

本文主要是介绍ORACLE 统计前三十天每天的数据量，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

select ChartDate,
(select count(*) from b2c_issuelists where to_date(substr(DEPOT_RECEIVING_DATETIME,1,10),'yyyy-MM-dd') = a.ChartDate ) AllData,
(select count(*) from b2c_issuelists
where QUO_START_DATETIME is not null and QUO_END_DATETIME is not null
and to_date(substr(DEPOT_RECEIVING_DATETIME,1,10),'yyyy-MM-dd') = a.ChartDate and REPAIR_STATUS != 9 and REPAIR_STATUS != 10) QUOTE,

(select count(*) from b2c_issuelists
where QUO_START_DATETIME is null and QUO_END_DATETIME is null
and to_date(substr(DEPOT_RECEIVING_DATETIME,1,10),'yyyy-MM-dd') = a.ChartDate and REPAIR_STATUS != 9 and REPAIR_STATUS != 10) NoQuote

from (SELECT trunc(FDATE) ChartDate
FROM (SELECT SYSDATE -rownum AS FDATE
FROM DUAL
CONNECT BY LEVEL <= 31) T
) a

这篇关于ORACLE 统计前三十天每天的数据量的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！