{"id":411,"date":"2021-07-20T10:09:03","date_gmt":"2021-07-20T10:09:03","guid":{"rendered":"http:\/\/www.hadooh.com\/?p=411"},"modified":"2021-07-20T10:09:03","modified_gmt":"2021-07-20T10:09:03","slug":"pivot%ec%9d%84-%ec%82%ac%ec%9a%a9%ed%95%b4%ec%84%9c-%eb%82%a0%ec%a7%9c%eb%b3%84%eb%a1%9c-%ea%b0%92%ec%9d%84-%eb%b3%b4%ec%97%ac%ec%a3%bc%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/www.hadooh.com\/?p=411","title":{"rendered":"pivot\uc744 \uc0ac\uc6a9\ud574\uc11c \ub0a0\uc9dc\ubcc4\ub85c \uac12\uc744 \ubcf4\uc5ec\uc8fc\uae30"},"content":{"rendered":"\n<p>\uc2dc\uc791\uc77c\uc790, \uc885\ub8cc\uc77c\uc790\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \uc6d0\ubcf8\ub370\uc774\ud130\uc640 \uce98\ub9b0\ub354 \ub370\uc774\ud130\ub97c \uc870\uc778\ud574\uc11c \uc77c\ubcc4\ub85c \uc0ac\uc6a9\uc790\uc758 \uc2e4\uc801\uc744 \ub9cc\ub4e4\uc5b4 \uc900 \ud6c4\uc5d0 pivot\uc744 \uc0ac\uc6a9\ud574\uc11c \ud55c\uc904\ub85c \uc0ac\uc6a9\uc790\uc758 \uc2e4\uc801\uc744 \ubcf4\uc5ec\uc900\ub2e4.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM (\n    SELECT AA.NAME, SUBSTR(BB.DT_DD,-2) AS DT_DD\n    FROM  \n        (\n            select 'HADOOH1' as name , '20210701' as startdt, '20210708' as enddt from dual union all\n            select 'HADOOH2' as name , '20210710' as startdt, '20210715' as enddt from dual union all\n            select 'HADOOH3' as name , '20210718' as startdt, '20210730' as enddt from dual\n        ) AA,\n        (\n            SELECT *  -- \ud574\ub2f9\uc6d4 \uce98\ub9b0\ub354\uc815\ubcf4\n            FROM CALENDAR\n            WHERE DT_DD LIKE '202107%'\n        ) BB\n    WHERE 1=1\n        AND BB.DT_DD BETWEEN AA.STARTDT AND AA.ENDDT\n    )\nPIVOT (\n        COUNT(*)\n        FOR DT_DD \n        IN ('01' as D01,'02' as D02,'03' as D03,'04' as D04,'05' as D05,'06' as D06,'07' as D07,'08' as D08,'09' as D09,'10' as D10\n        ,'11' as D11,'12' as D12,'13' as D13,'14' as D14,'15' as D15,'16' as D16,'17' as D17,'18' as D18,'19' as D19,'20' as D20\n        ,'21' as D21,'22' as D22,'23' as D23,'24' as D24,'25' as D25,'26' as D26,'27' as D27,'28' as D28,'29' as D29,'30' as D30\n        ,'31' as D31)\n      )<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"270\" height=\"98\" src=\"https:\/\/www.hadooh.com\/wp-content\/uploads\/2021\/07\/hadooh_calender0.jpg\" alt=\"\" class=\"wp-image-414\"\/><figcaption>\uc6d0\ubcf8\ub370\uc774\ud130<br><\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"73\" src=\"https:\/\/www.hadooh.com\/wp-content\/uploads\/2021\/07\/hadooh_calender1-1024x73.jpg\" alt=\"\" class=\"wp-image-413\" srcset=\"https:\/\/www.hadooh.com\/wp-content\/uploads\/2021\/07\/hadooh_calender1-1024x73.jpg 1024w, https:\/\/www.hadooh.com\/wp-content\/uploads\/2021\/07\/hadooh_calender1-300x21.jpg 300w, https:\/\/www.hadooh.com\/wp-content\/uploads\/2021\/07\/hadooh_calender1-768x55.jpg 768w, https:\/\/www.hadooh.com\/wp-content\/uploads\/2021\/07\/hadooh_calender1.jpg 1496w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>\uacb0\uacfc\uac12<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\uc2dc\uc791\uc77c\uc790, \uc885\ub8cc\uc77c\uc790\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \uc6d0\ubcf8\ub370\uc774\ud130\uc640 \uce98\ub9b0\ub354 \ub370\uc774\ud130\ub97c \uc870\uc778\ud574\uc11c \uc77c\ubcc4\ub85c \uc0ac\uc6a9\uc790\uc758 \uc2e4\uc801\uc744 \ub9cc\ub4e4\uc5b4 \uc900 \ud6c4\uc5d0 pivot\uc744 \uc0ac\uc6a9\ud574\uc11c \ud55c\uc904\ub85c \uc0ac\uc6a9\uc790\uc758 \uc2e4\uc801\uc744 \ubcf4\uc5ec\uc900\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/posts\/411"}],"collection":[{"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=411"}],"version-history":[{"count":1,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/posts\/411\/revisions"}],"predecessor-version":[{"id":415,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/posts\/411\/revisions\/415"}],"wp:attachment":[{"href":"https:\/\/www.hadooh.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}