{"id":1176,"date":"2016-01-03T10:04:31","date_gmt":"2016-01-03T10:04:31","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1176"},"modified":"2016-01-03T10:04:31","modified_gmt":"2016-01-03T10:04:31","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%8b%a4%ec%a4%91-%ec%97%b4-%ec%84%9c%eb%b8%8c%ec%bf%bc%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/haisins.synology.me\/wordpress\/?p=1176","title":{"rendered":"\uc624\ub77c\ud074 \ub2e4\uc911 \uc5f4 \uc11c\ube0c\ucffc\ub9ac"},"content":{"rendered":"

# \ub2e4\uc911 \uc5f4 \uc11c\ube0c\ucffc\ub9ac <\/SPAN><\/P>
\n

\ub2e4\uc911 \uc5f4 \uc11c\ube0c\ucffc\ub9ac\ub780 \uc11c\ube0c\ucffc\ub9ac\uc758 \uacb0\uacfc\uac12\uc774 \ub450\uac1c \uc774\uc0c1\uc758 \uceec\ub7fc\uc744 \ubc18\ud658\ud558\ub294 \uc11c\ube0c\ucffc\ub9ac \uc785\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

\uc11c\ube0c\ucffc\ub9ac\uac00 \ud55c\ubc88 \uc2e4\ud589\ub418\uba74\uc11c \ubaa8\ub4e0 \uc870\uac74\uc744 \uac80\uc0c9\ud574\uc11c \uc8fc \ucffc\ub9ac\ub85c \ub118\uaca8 \uc90d\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

ex) SELECT empno, sal, deptno <\/SPAN><\/P>
\n

FROM emp <\/SPAN><\/P>
\n

WHERE (sal, deptno) IN ( SELECT sal, deptno <\/SPAN><\/P>
\n

FROM emp <\/SPAN><\/P>
\n

WHERE deptno = 30 <\/SPAN><\/P>
\n

AND comm is NOT NULL ); <\/SPAN><\/P>
\n

 <\/P>
\n

EMPNO SAL DEPTNO <\/SPAN><\/P>
\n

———- ———- ———- <\/SPAN><\/P>
\n

7521 1250 30 <\/SPAN><\/P>
\n

7654 1250 30 <\/SPAN><\/P>
\n

7844 1500 30 <\/SPAN><\/P>
\n

7499 1600 30 <\/SPAN><\/P>
\n

   <\/P>
\n

\uc11c\ube0c\ucffc\ub9ac\uac00 \uc5ec\ub7ec \uc870\uac74\ubcc4\ub85c \uc0ac\uc6a9 \ub418\uc5b4\uc11c \uacb0\uacfc\uac12\uc744 \uc8fc \ucffc\ub9ac\ub85c \ub118\uaca8 \uc90d\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

ex) SELECT empno, sal, deptno <\/SPAN><\/P>
\n

FROM emp <\/SPAN><\/P>
\n

WHERE sal IN ( SELECT sal <\/SPAN><\/P>
\n

FROM emp <\/SPAN><\/P>
\n

WHERE deptno = 30 <\/SPAN><\/P>
\n

AND comm is NOT NULL ) <\/SPAN><\/P>
\n

AND deptno IN ( SELECT deptno <\/SPAN><\/P>
\n

FROM emp <\/SPAN><\/P>
\n

WHERE deptno = 30 <\/SPAN><\/P>
\n

AND comm is NOT NULL ); <\/SPAN><\/P>
\n

   <\/P>
\n

EMPNO SAL DEPTNO <\/SPAN><\/P>
\n

———- ———- ———- <\/SPAN><\/P>
\n

7521 1250 30 <\/SPAN><\/P>
\n

7654 1250 30 <\/SPAN><\/P>
\n

7844 1500 30 <\/SPAN><\/P>
\n

7499 1600 30 <\/SPAN><\/P>
\n

   <\/P>
\n

\uc11c\ube0c\ucffc\ub9ac\uc5d0\uc11c null\uac12\uc774 \ubc18\ud658\ub418\uba74 \uc8fc \ucffc\ub9ac \uc5d0\uc11c\ub294 \uc5b4\ub5a0\ud55c \ud589\ub3c4 \ubc18\ud658\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

# \ub2e4\uc911 \uc5f4 \uc11c\ube0c\ucffc\ub9ac \ub2e4\uc911 \uc5f4 \uc11c\ube0c\ucffc\ub9ac\ub780 \uc11c\ube0c\ucffc\ub9ac\uc758 \uacb0\uacfc\uac12\uc774 \ub450\uac1c \uc774\uc0c1\uc758 \uceec\ub7fc\uc744 \ubc18\ud658\ud558\ub294 \uc11c\ube0c\ucffc\ub9ac \uc785\ub2c8\ub2e4.     \uc11c\ube0c\ucffc\ub9ac\uac00 \ud55c\ubc88 \uc2e4\ud589\ub418\uba74\uc11c \ubaa8\ub4e0 \uc870\uac74\uc744 \uac80\uc0c9\ud574\uc11c \uc8fc \ucffc\ub9ac\ub85c \ub118\uaca8 \uc90d\ub2c8\ub2e4.     ex) SELECT empno, sal, deptno FROM emp WHERE (sal, deptno) IN ( SELECT sal, deptno FROM emp WHERE deptno = 30 AND comm is NOT NULL […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[665,663],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1176"}],"collection":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1176"}],"version-history":[{"count":0,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1176\/revisions"}],"wp:attachment":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}