oracle
头大如钟
这个作者很懒,什么都没留下…
展开
-
oracle按年月日统计,无数据补0
年select b.DAY_TIME xaxis, nvl(a.yaxis,0) yaxis from ( select substr(o.CREATEDATE, 1,4) xaxis, count(*) yaxis from T_YY_ORDERDETAIL od inner join T_YY_ORDER o on od.ORDERID=o.ORDERID inner join T_YY_SERVICEINTERFACE sif on sif.ID=od.SERVICEID WHERE o.ORDE原创 2020-05-28 16:45:31 · 1771 阅读 · 0 评论 -
oracle统计一段时间内每天的数据量,无数据是自动补零!
select a.time,nvl(b.num,0) as num from (select to_char(to_date('2018/07/20', 'yyyy-mm-dd') + rownum - 1, 'yyyy-mm-dd') as timefrom dualconnect by rownum <= trunc(...原创 2018-12-29 16:13:28 · 4740 阅读 · 0 评论