SELECT DT, NVL(XVAL0,0)
FROM
( SELECT TO_CHAR((SYSDATE - LEVEL + 1), \'MM/DD\') DT
FROM DUAL
CONNECT BY SYSDATE - LEVEL + 1 > SYSDATE - 30
) A
LEFT OUTER JOIN
( SELECT DT1, MAX(XVAL0) AS XVAL0
FROM (
SELECT TO_CHAR(FROM_UNIXTIME(DT), \'MM/DD\') AS DT1, XVAL0
FROM MXSMSMONSCRIPT_
WHERE LISTID=2100
AND SYSDATE - TO_DATE(TO_CHAR(FROM_UNIXTIME(DT), \'YYYYMMDD\'),\'YYYYMMDD\') < 30
)
GROUP BY DT1
) B
ON DT=DT1
ORDER BY DT
Á¦°¡ °³¹ßÀÚµµ ¾Æ´Ï°í... DB Äõ¸®¿¡ ¸¹ÀÌ ½Ç·ÂÀÌ µþ¸®´Âµ¥¿ä...
outer join ¾²¸é ¼º´É¿¡ ÁÁÁö ¾Ê´Ù´Â ¾ê±âµµ ¾îµð¼ º»°Å°°°í~~ Á¶¾ð Á» ºÎŹµå¸±°Ô¿ä~~~ ^^
SELECT DT, NVL(XVAL0,0)
FROM
( SELECT TO_CHAR((SYSDATE - LEVEL + 1), \'MM/DD\') DT
FROM DUAL
CONNECT BY SYSDATE - LEVEL + 1 > SYSDATE - 30
) A
LEFT OUTER JOIN
( SELECT DT1, MAX(XVAL0) AS XVAL0
FROM (
SELECT TO_CHAR(FROM_UNIXTIME(DT), \'MM/DD\') AS DT1, XVAL0
FROM MXSMSMONSCRIPT_
WHERE LISTID=2100
AND SYSDATE - TO_DATE(TO_CHAR(FROM_UNIXTIME(DT), \'YYYYMMDD\'),\'YYYYMMDD\') < 30
)
GROUP BY DT1
) B
ON DT=DT1
ORDER BY DT