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

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

\ud558\ub098 \uc774\uc0c1\uc758 \ud589\uc744 RETURN\ud558\ub294 SUBQUERY\ub97c \ub2e4\uc911 \ud589 SUBQUERY\ub77c\uace0 \ud569\ub2c8\ub2e4. <\/SPAN><\/SPAN><\/P>
\n

\ubcf5\uc218 \ud589 \uc5f0\uc0b0\uc790(IN, NOT IN, ANY, ALL, EXISTS)\ub97c \uc0ac\uc6a9 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

# \uc608\uc81c <\/SPAN><\/P>
\n

IN \uc5f0\uc0b0\uc790 \uc0ac\uc6a9 \uc608\uc81c <\/SPAN><\/P>
\n

\uc608\uc81c)\ubd80\uc11c\ubcc4\ub85c \uac00\uc7a5 \uae09\uc5ec\ub97c \ub9ce\uc774 \ubc1b\ub294 \uc0ac\uc6d0\uc758
\uc815\ubcf4\ub97c \ucd9c\ub825\ud558\ub294 \uc608\uc81c \uc785\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

SQL>SELECT empno,ename,sal,deptno <\/SPAN><\/P>
\n

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

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

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

GROUP BY deptno); <\/SPAN><\/P>
\n

 <\/P>
\n

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

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

7698 BLAKE 2850 30 <\/SPAN><\/P>
\n

7788 SCOTT 3000 20 <\/SPAN><\/P>
\n

7902 FORD 3000 20 <\/SPAN><\/P>
\n

7839 KING 5000 10 <\/SPAN><\/P>
\n

   <\/P>
\n

ANY \uc5f0\uc0b0\uc790 \uc0ac\uc6a9 \uc5d0\uc81c <\/SPAN><\/P>
\n

– ANY\uc5f0\uc0b0\uc790\ub294 \uc11c\ube0c\ucffc\ub9ac\uc758 \uacb0\uacfc\uac12\uc911 \uc5b4\ub290 \ud558\ub098\uc758 \uac12\uc774\ub77c\ub3c4
\ub9cc\uc871\uc774 \ub418\uba74 \uacb0\uacfc\uac12\uc744 \ubc18\ud658 \ud569\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

SQL>SELECT ename, sal <\/SPAN><\/P>
\n

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

WHERE deptno != 20 <\/SPAN><\/P>
\n

AND sal > ANY(SELECT sal
FROM emp
WHERE job=’SALESMAN’); <\/SPAN><\/P>
\n

   <\/P>
\n

ENAME SAL <\/SPAN><\/P>
\n

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

ALLEN 1600 <\/SPAN><\/P>
\n

BLAKE 2850 <\/SPAN><\/P>
\n

CLARK 2450 <\/SPAN><\/P>
\n

KING 5000 <\/SPAN><\/P>
\n

TURNER 1500 <\/SPAN><\/P>
\n

MILLER 1300 <\/SPAN><\/P>
\n

   <\/P>
\n

6 \uac1c\uc758 \ud589\uc774 \uc120\ud0dd\ub418\uc5c8\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

ALL \uc5f0\uc0b0\uc790 \uc0ac\uc6a9 \uc608\uc81c <\/SPAN><\/P>
\n

– ALL\uc5f0\uc0b0\uc790\ub294 \uc11c\ube0c\ucffc\ub9ac\uc758 \uacb0\uacfc\uac12\uc911 \ubaa8\ub4e0 \uacb0\uacfc \uac12\uc774
\ub9cc\uc871 \ub418\uc57c\ub9cc \uacb0\uacfc\uac12\uc744 \ubc18\ud658 \ud569\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

SQL>SELECT ename, sal <\/SPAN><\/P>
\n

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

WHERE deptno != 20 <\/SPAN><\/P>
\n

AND sal > ALL(SELECT sal
FROM emp
WHERE job=’SALESMAN’); <\/SPAN><\/P>
\n

   <\/P>
\n

ENAME SAL <\/SPAN><\/P>
\n

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

BLAKE 2850 <\/SPAN><\/P>
\n

CLARK 2450 <\/SPAN><\/P>
\n

KING 5000 <\/SPAN><\/P>
\n

3 \uac1c\uc758 \ud589\uc774 \uc120\ud0dd\ub418\uc5c8\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

EXISTS \uc5f0\uc0b0\uc790 \uc0ac\uc6a9 \uc608\uc81c <\/SPAN><\/P>
\n

– EXISTS \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud558\uba74 \uc11c\ube0c\ucffc\ub9ac\uc758 \ub370\uc774\ud130\uac00 \uc874\uc7ac\ud558\ub294\uac00\uc758
\uc5ec\ubd80\ub97c \uba3c\uc800 \ub530\uc838 \uc874\uc7ac\ud558\ub294 \uac12\ub4e4\ub9cc\uc744 \uacb0\uacfc\ub85c \ubc18\ud658\ud574 \uc90d\ub2c8\ub2e4. <\/SPAN><\/P>
\n

– SUBQUERY\uc5d0\uc11c \uc801\uc5b4\ub3c4 1\uac1c\uc758 \ud589\uc744 RETURN\ud558\uba74 \ub17c\ub9ac\uc2dd\uc740 \ucc38\uc774\uace0
\uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \uac70\uc9d3 \uc785\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

\uc608\uc81c)\uc0ac\uc6d0\uc744 \uad00\ub9ac\ud560 \uc218 \uc788\ub294 \uc0ac\uc6d0\uc758 \uc815\ubcf4\ub97c \ubcf4\uc5ec \uc90d\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

SELECT empno, ename, sal <\/SPAN><\/P>
\n

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

WHERE EXISTS (SELECT empno
FROM emp
WHERE e.empno = mgr) <\/SPAN><\/P>
\n

   <\/P>
\n

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

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

7566 JONES 2975 <\/SPAN><\/P>
\n

7698 BLAKE 2850 <\/SPAN><\/P>
\n

7782 CLARK 2450 <\/SPAN><\/P>
\n

7788 SCOTT 3000 <\/SPAN><\/P>
\n

7839 KING 5000 <\/SPAN><\/P>
\n

7902 FORD 3000 <\/SPAN><\/P>
\n

   <\/P>
\n

6 \uac1c\uc758 \ud589\uc774 \uc120\ud0dd\ub418\uc5c8\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P>
\n

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

# \ub2e4\uc911 \ud589 \uc11c\ube0c\ucffc\ub9ac \ud558\ub098 \uc774\uc0c1\uc758 \ud589\uc744 RETURN\ud558\ub294 SUBQUERY\ub97c \ub2e4\uc911 \ud589 SUBQUERY\ub77c\uace0 \ud569\ub2c8\ub2e4. \ubcf5\uc218 \ud589 \uc5f0\uc0b0\uc790(IN, NOT IN, ANY, ALL, EXISTS)\ub97c \uc0ac\uc6a9 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.     # \uc608\uc81c IN \uc5f0\uc0b0\uc790 \uc0ac\uc6a9 \uc608\uc81c \uc608\uc81c)\ubd80\uc11c\ubcc4\ub85c \uac00\uc7a5 \uae09\uc5ec\ub97c \ub9ce\uc774 \ubc1b\ub294 \uc0ac\uc6d0\uc758 \uc815\ubcf4\ub97c \ucd9c\ub825\ud558\ub294 \uc608\uc81c \uc785\ub2c8\ub2e4.     SQL>SELECT empno,ename,sal,deptno FROM emp WHERE sal IN (SELECT MAX(sal) FROM […]<\/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":[664,663],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1175"}],"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=1175"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1175\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1175"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}