{"id":1173,"date":"2016-01-03T10:04:04","date_gmt":"2016-01-03T10:04:04","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1173"},"modified":"2016-01-03T10:04:04","modified_gmt":"2016-01-03T10:04:04","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%8b%a8%ec%9d%bc-%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=1173","title":{"rendered":"\uc624\ub77c\ud074 \ub2e8\uc77c \ud589 \uc11c\ube0c\ucffc\ub9ac"},"content":{"rendered":"<p><P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"># \ub2e8\uc77c \ud589 \uc11c\ube0c \ucffc\ub9ac <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\uc624\uc9c1 \ud55c\uac1c\uc758 \ud589(\uac12)\uc744 \ubc18\ud658 \ud569\ub2c8\ub2e4.(Return only one row) <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"><br \/>\ub2e8\uc77c \ud589 \uc5f0\uc0b0\uc790(=,&gt;, &gt;=, &lt;, &lt;=, &lt;&gt;, !=) \ub9cc <br \/>\uc0ac\uc6a9 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; SELECT ename,job <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">FROM emp <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">WHERE job = (SELECT job <br \/>FROM emp <br \/>WHERE empno = 7369); <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\uc704\uc758 \uc11c\ube0c\ucffc\ub9ac\ub97c \uc2e4\ud589 \uc2dc\ud0a4\uba74. \uc624\ub978\ucabd\uc758 \uadf8\ub9bc\ucc98\ub7fc. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">empno\uac00 7369\uc778 job\uc744 \uba3c\uc800 \uac80\uc0c9\ud558\uace0.. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">job\uc774 &#8216;CLERK&#8217;\uc778 \uc0ac\uc6d0\uc758 \uc774\ub984\uacfc \uc9c1\uc5c5\uc744 \ubc18\ud658 \ud569\ub2c8\ub2e4. <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile3.uf.2527C24B5688F2131A1328.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">&nbsp; <\/SPAN>&nbsp;<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p># \ub2e8\uc77c \ud589 \uc11c\ube0c \ucffc\ub9ac \uc624\uc9c1 \ud55c\uac1c\uc758 \ud589(\uac12)\uc744 \ubc18\ud658 \ud569\ub2c8\ub2e4.(Return only one row) \ub2e8\uc77c \ud589 \uc5f0\uc0b0\uc790(=,&gt;, &gt;=, &lt;, &lt;=, &lt;&gt;, !=) \ub9cc \uc0ac\uc6a9 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. &nbsp; SQL&gt; SELECT ename,job FROM emp WHERE job = (SELECT job FROM emp WHERE empno = 7369); &nbsp; &nbsp; \uc704\uc758 \uc11c\ube0c\ucffc\ub9ac\ub97c \uc2e4\ud589 \uc2dc\ud0a4\uba74. \uc624\ub978\ucabd\uc758 \uadf8\ub9bc\ucc98\ub7fc. empno\uac00 7369\uc778 job\uc744 \uba3c\uc800 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1174,"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":[662,663],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile3.uf.2527C24B5688F2131A1328.png?fit=420%2C449","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1173"}],"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=1173"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1173\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1174"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1173"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}