查询本月每天数据（不管有没有数据）

最新推荐文章于 2024-03-27 17:45:03 发布

Wawtt@小超

最新推荐文章于 2024-03-27 17:45:03 发布

阅读量477

点赞数

本文链接：https://blog.csdn.net/ios8859_2/article/details/87911131

版权



SELECT A.FDATE, COUNT(B.STARTDATE) FNUM
  		FROM (SELECT FDATE
          FROM (SELECT TRUNC(to_date(#{thisTime},'YYYY-MM-DD'), 'MONTH') + LEVEL - 1 AS FDATE
                  FROM DUAL
                CONNECT BY LEVEL <= 31) T
         WHERE TO_CHAR(FDATE, 'MM') = TO_CHAR(to_date(#{thisTime},'YYYY-MM-DD'), 'MM')) A
  		LEFT JOIN (SELECT STARTDATE, ENDDATE
               FROM GBJXKH_V_DAILYTASK
              WHERE USERID = #{user001}) B
    		ON TRUNC(B.STARTDATE) <= A.FDATE
   		AND TRUNC(B.ENDDATE + 1) > A.FDATE
   		GROUP BY A.FDATE
 		ORDER BY A.FDATE



SELECT 10 + LEVEL*10 AS FDATE
  FROM DUAL
CONNECT BY LEVEL <= 10