
统计经典SQL(构建日期补0)
SELECT A.DAYLIST, NVL(B.MBC, 0) MBC,CAST(NVL(B.SC, 0) AS NUMBER(10, 2)) SCFROM (SELECT TO_DATE(TO_CHAR(TO_DATE(‘20...
SELECT A.DAYLIST, NVL(B.MBC, 0) MBC,CAST(NVL(B.SC, 0) AS NUMBER(10, 2)) SCFROM (SELECT TO_DATE(TO_CHAR(TO_DATE(‘20...