{"id":1177,"date":"2016-01-03T10:05:28","date_gmt":"2016-01-03T10:05:28","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1177"},"modified":"2016-01-03T10:05:28","modified_gmt":"2016-01-03T10:05:28","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%a7%91%ed%95%a9%ec%bf%bc%eb%a6%ac-1","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1177","title":{"rendered":"\uc624\ub77c\ud074 \uc9d1\ud569\ucffc\ub9ac"},"content":{"rendered":"

# \uc9d1\ud569\ucffc\ub9ac <\/SPAN><\/P>
\n

\uc9d1\ud569 \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\uc2dc \uc9d1\ud569\uc744 \uad6c\uc131\ud560 \uceec\ub7ec\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc774 \ub3d9\uc77c\ud574\uc57c \ud569\ub2c8\ub2e4. <\/SPAN><\/P>
\n

UNION :\ud569\uc9d1\ud569 <\/SPAN>\u25c8<\/SPAN> UNION ALL:\uacf5\ud1b5\uc6d0\uc18c \ub450\ubc88\uc529 \ub2e4 \ud3ec\ud568\ud55c \ud569\uc9d1\ud569 <\/SPAN><\/SPAN><\/P>
\n

INTERSECT:\uad50\uc9d1\ud569 <\/SPAN>\u25c8<\/SPAN> MINUS:\ucc28\uc9d1\ud569 <\/SPAN><\/SPAN><\/P>
\n

   <\/P>
\n

UNION\uc740 \ub450 \ud14c\uc774\ube14\uc758 \uacb0\ud569\uc744 \ub098\ud0c0\ub0b4\uba70, \uacb0\ud569\uc2dc\ud0a4\ub294 \ub450 \ud14c\uc774\ube14\uc758 \uc911\ubcf5\ub418\uc9c0 \uc54a\uc740 \uac12\ub4e4\uc744 \ubc18\ud658 \ud569\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

   <\/P>
\n

SQL>SELECT deptno FROM emp <\/SPAN><\/P>
\n

UNION <\/SPAN><\/P>
\n

SELECT deptno FROM dept; <\/SPAN><\/P>
\n

   <\/P>
\n

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

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

10 <\/SPAN><\/P>
\n

20 <\/SPAN><\/P>
\n

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

40 <\/SPAN><\/P>
\n

   <\/P>
\n

\u25c8<\/SPAN> UNION\uacfc \uac19\uc73c\ub098 \ub450 \ud14c\uc774\ube14\uc758 \uc911\ubcf5\ub418\ub294 \uac12\uae4c\uc9c0 \ubc18\ud658 \ud569\ub2c8\ub2e4. <\/SPAN><\/SPAN><\/P>
\n

   <\/P>
\n

SQL>SELECT deptno FROM emp <\/SPAN><\/P>
\n

UNION ALL <\/SPAN><\/P>
\n

SELECT deptno FROM dept; <\/SPAN><\/P>
\n

   <\/P>
\n

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

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

20 <\/SPAN><\/P>
\n

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

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

20 <\/SPAN><\/P>
\n

10 <\/SPAN><\/P>
\n

20 <\/SPAN><\/P>
\n

10 <\/SPAN><\/P>
\n

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

…. <\/SPAN><\/P>
\n

   <\/P>
\n

\u25c8<\/SPAN> INTERSECT\ub294 \ub450 \ud589\uc758 \uc9d1\ud569\uc911 \uacf5\ud1b5\ub41c \ud589\uc744 \ubc18\ud658 \ud569\ub2c8\ub2e4. <\/SPAN><\/SPAN><\/P>
\n

   <\/P>
\n

SQL>SELECT deptno FROM emp <\/SPAN><\/P>
\n

INTERSECT <\/SPAN><\/P>
\n

SELECT deptno FROM dept; <\/SPAN><\/P>
\n

 <\/P>
\n

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

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

10 <\/SPAN><\/P>
\n

20 <\/SPAN><\/P>
\n

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

   <\/P>
\n

\u25c8<\/SPAN> MINUS\ub294 \uccab\ubc88\uc9f8 SELECT\ubb38\uc5d0 \uc758\ud574 \ubc18\ud658\ub418\ub294 \ud589\uc911\uc5d0\uc11c \ub450\ubc88\uc9f8 SELECT\ubb38\uc5d0 \uc758\ud574 \ubc18\ud658\ub418\ub294 \ud589\uc5d0 \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294 \ud589\ub4e4\uc744 \ubcf4\uc5ec \uc90d\ub2c8\ub2e4. <\/SPAN><\/SPAN><\/P>
\n

   <\/P>
\n

SQL>SELECT deptno FROM dept <\/SPAN><\/P>
\n

MINUS <\/SPAN><\/P>
\n

SELECT deptno FROM emp; <\/SPAN><\/P>
\n

   <\/P>
\n

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

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

40 <\/SPAN><\/P>
\n

   <\/P>
\n

  <\/SPAN> <\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

# \uc9d1\ud569\ucffc\ub9ac \uc9d1\ud569 \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\uc2dc \uc9d1\ud569\uc744 \uad6c\uc131\ud560 \uceec\ub7ec\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc774 \ub3d9\uc77c\ud574\uc57c \ud569\ub2c8\ub2e4. UNION :\ud569\uc9d1\ud569 \u25c8 UNION ALL:\uacf5\ud1b5\uc6d0\uc18c \ub450\ubc88\uc529 \ub2e4 \ud3ec\ud568\ud55c \ud569\uc9d1\ud569 INTERSECT:\uad50\uc9d1\ud569 \u25c8 MINUS:\ucc28\uc9d1\ud569     UNION\uc740 \ub450 \ud14c\uc774\ube14\uc758 \uacb0\ud569\uc744 \ub098\ud0c0\ub0b4\uba70, \uacb0\ud569\uc2dc\ud0a4\ub294 \ub450 \ud14c\uc774\ube14\uc758 \uc911\ubcf5\ub418\uc9c0 \uc54a\uc740 \uac12\ub4e4\uc744 \ubc18\ud658 \ud569\ub2c8\ub2e4.         SQL>SELECT deptno FROM emp UNION SELECT deptno FROM dept;     DEPTNO […]<\/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":[666],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1177"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1177"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1177\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1177"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}