union, intersect, minus, union all<\/p>\n
union, intersect, minus, union all \ub294 \uc5f0\uc0b0\uc2dc relation degree(\uceec\ub7fc\uac1c\uc218)\uac00 \ub3d9\uc77c\ud574\uc57c \ud55c\ub2e4.
\n\ud655\uc778\ud558\ub294 \ucc28\uc6d0\uc5d0\uc11c \uac04\ub2e8\ud55c \ud6d1\uc5b4\ubcf4\uaca0\ub2e4.<\/p>\n
[test1 \ud14c\uc774\ube14]
\nID NAME
\n———- ———-
\nmaddog \uac15\uba85\uaddc
\ntest1 \uc544\ubb34\uac1c1<\/p>\n
[test2 \ud14c\uc774\ube14]
\nID NAME
\n———- ———-
\nmaddog \uac15\uba85\uaddc
\ntest2 \uc544\ubb34\uac1c2<\/p>\n
SQL> create table test1 (id varchar(10), name varchar(10));
\nSQL> create table test2 (id varchar(10), name varchar(10));
\nSQL> insert into test1 values(‘maddog’, ‘\uac15\uba85\uaddc’);
\nSQL> insert into test2 values(‘maddog’, ‘\uac15\uba85\uaddc’);
\nSQL> insert into test1 values(‘test1’, ‘\uc544\ubb34\uac1c1’);
\nSQL> insert into test2 values(‘test2’, ‘\uc544\ubb34\uac1c2’);<\/p>\n
[union]
\nSQL> select * from test1
\n 2 union
\n 3 select * from test2;<\/p>\n
ID NAME
\n———- ———-
\nmaddog \uac15\uba85\uaddc
\ntest1 \uc544\ubb34\uac1c1
\ntest2 \uc544\ubb34\uac1c2<\/p>\n
[union all]
\nSQL> select * from test1
\n 2 union all
\n 3 select * from test2;<\/p>\n
ID NAME
\n———- ———-
\nmaddog \uac15\uba85\uaddc
\ntest1 \uc544\ubb34\uac1c1
\nmaddog \uac15\uba85\uaddc
\ntest2 \uc544\ubb34\uac1c2<\/p>\n
* union\uc758 \uacbd\uc6b0, \uc911\ubcf5\ud589\uc744 \uc81c\uac70\ud558\uae30 \uc704\ud55c \ubd80\ud558\uac00 \ubc1c\uc0dd\ud558\ubbc0\ub85c \uc911\ubcf5\ub418\ub294 \ub808\ucf54\ub4dc\uc5d0 \ubb34\uad00\ud55c \uc791\uc5c5\uc774\ub77c\uba74 \ub418\ub3c4\ub85d union all\uc744 \uc0ac\uc6a9\ud558\ub3c4\ub85d \ud558\ub77c.<\/p>\n
[intersect]
\nSQL> select * from test1
\n 2 intersect
\n 3 select * from test2;<\/p>\n
ID NAME
\n———- ———-
\nmaddog \uac15\uba85\uaddc<\/p>\n
[minus]
\nSQL> select * from test1
\n 2 minus
\n 3 select * from test2;<\/p>\n
ID NAME
\n———- ———-
\ntest1 \uc544\ubb34\uac1c1<\/p>\n
union, intersect, minus, union all\uc911 \ucc28\uc9d1\ud569(minus)\uc740 \uad50\ud658\ubc95\uce59\uc774 \uc131\ub9bd\ub418\uc9c0 \uc54a\ub294\ub2e4.
\n\uadf8\ub7fc test1, test2\uc758 \uc21c\uc11c\ub97c \ubc14\uafb8\uc5b4(\uad50\ud658\ubc95\uce59) \ud655\uc778\ud574\ubcf4\uc790.<\/p>\n
SQL> select * from test2
\n 2 union
\n 3 select * from test1;<\/p>\n
ID NAME
\n———- ———-
\nmaddog \uac15\uba85\uaddc
\ntest1 \uc544\ubb34\uac1c1
\ntest2 \uc544\ubb34\uac1c2<\/p>\n
SQL> select * from test2
\n 2 intersect
\n 3 select * from test1;<\/p>\n
ID NAME
\n———- ———-
\nmaddog \uac15\uba85\uaddc<\/p>\n
SQL> select * from test2
\n 2 minus
\n 3 select * from test1;<\/p>\n
ID NAME
\n———- ———-
\ntest2 \uc544\ubb34\uac1c2<\/p>\n
SQL> <\/p>\n
This article comes from dbakorea.pe.kr (Leave this line as is)<\/p>\n","protected":false},"excerpt":{"rendered":"
union, intersect, minus, union all union, intersect, minus, union all \ub294 \uc5f0\uc0b0\uc2dc relation degree(\uceec\ub7fc\uac1c\uc218)\uac00 \ub3d9\uc77c\ud574\uc57c \ud55c\ub2e4. \ud655\uc778\ud558\ub294 \ucc28\uc6d0\uc5d0\uc11c \uac04\ub2e8\ud55c \ud6d1\uc5b4\ubcf4\uaca0\ub2e4. [test1 \ud14c\uc774\ube14] ID NAME ———- ———- maddog \uac15\uba85\uaddc test1 \uc544\ubb34\uac1c1… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/498"}],"collection":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=498"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/498\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}