¾È³çÇϼ¼¿ä~
¿À¶óŬ Äõ¸® »ç¿ëÇغ»Áö 5³âµµ ´õ µÆ³×¿ä... ±â¾ïµµ °¡¹°°¡¹°ÇÏ°í °Ë»öÇصµ Àß ¸øã°Ú¾î¼ Áú¹®ÇÕ´Ï´Ù ^^;;;
±âÁØ Å×À̺íÀº °£´ÜÈ÷ ³¯Â¥¿Í °ªÀ¸·Î ÀÌ·ç¾îÁ® ÀÖ´Ù°í º¸½Ã¸é µË´Ï´Ù.
¿À´ÃÀ» ±âÁØÀ¸·Î 30ÀÏ°£ÀÇ ³¯Â¥¿¡ ´ëÇÑ °ªµéÀ» Ãâ·ÂÇØÁÖ¸é µÇ´Âµ¥¿ä...
Áß¿äÇÑ°Ç, Áß°£ Áß°£¿¡ ºñ´Â ³¯Â¥°¡ ÀÖ´Ù´Â °ÅÁÒ. ;;;
ÀÌ·²°æ¿ì ÇØ´ç ³¯Â¥¸¦ ¸Å²ã³Ö¾îÁÖ°í 0À¸·Î Ç¥½ÃÇÏ¸é µÉ µí Çѵ¥¿ä...
¾Æ½Ã´Â ºÐ ´äº¯ Á» ºÎŹÇÒ°Ô¿ä~~ ²Ù¹÷! | |
|
Á¦°¡ °³¹ßÀÚµµ ¾Æ´Ï°í... 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