{"id":364,"date":"2024-04-18T22:32:52","date_gmt":"2024-04-18T13:32:52","guid":{"rendered":"https:\/\/sejiwon.com\/?p=364"},"modified":"2024-04-18T22:32:52","modified_gmt":"2024-04-18T13:32:52","slug":"%ec%a0%84%ec%b2%b4%eb%b2%94%ec%9c%84%ec%b2%98%eb%a6%ac%ec%99%80-%eb%b6%80%eb%b6%84%eb%b2%94%ec%9c%84%ec%b2%98%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=364","title":{"rendered":"\uc804\uccb4\ubc94\uc704\ucc98\ub9ac\uc640 \ubd80\ubd84\ubc94\uc704\ucc98\ub9ac"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"884\" height=\"594\" src=\"https:\/\/sejiwon.com\/wp-content\/uploads\/2024\/04\/image-1.png\" alt=\"\" class=\"wp-image-359\" srcset=\"https:\/\/sejiwon.com\/wp-content\/uploads\/2024\/04\/image-1.png 884w, https:\/\/sejiwon.com\/wp-content\/uploads\/2024\/04\/image-1-300x202.png 300w, https:\/\/sejiwon.com\/wp-content\/uploads\/2024\/04\/image-1-768x516.png 768w, https:\/\/sejiwon.com\/wp-content\/uploads\/2024\/04\/image-1-660x443.png 660w\" sizes=\"(max-width: 884px) 100vw, 884px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>\uc804\uccb4\ubc94\uc704\ucc98\ub9ac\ub294 \ubb34\uc5c7\uc774\uace0, \ubd80\ubd84\ubc94\uc704\ucc98\ub9ac\ub294 \ubb34\uc5c7\uc778\uc9c0 \uc54c\uc544\ubcf4\ub3c4\ub85d \ud569\uc2dc\ub2e4.<\/p>\n\n\n\n<p>\uc544\uc8fc \uac04\ub2e8\ud558\uac8c \uc124\uba85\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select *\n  from table\n;\n\n<\/code><\/pre>\n\n\n\n<p>\uc704 SQL\uc740 \uc804\uccb4\ubc94\uc704\ucc98\ub9ac\uc77c\uae4c\uc694?<\/p>\n\n\n\n<p>\uc804\uccb4\ub97c \ub300\uc0c1\uc73c\ub85c \ud558\ub2c8\uae4c \uc804\uccb4\ubc94\uc704\ucc98\ub9ac\uac00 \uc544\ub2d0\uae4c\uc694?<\/p>\n\n\n\n<p>\uc800\ub807\uac8c \ucffc\ub9ac\ub97c \uc791\uc131\ud558\uba74 \uacb0\uacfc\uac00 \ube68\ub9ac\ub098\uc624\ub098\uc694? \uc544\ub2c8\uba74 \ub2a6\uac8c \ub098\uc624\ub098\uc694?<\/p>\n\n\n\n<p>\uacb0\uacfc\uac00 \ube68\ub9ac \ub098\uc635\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\uc720\ub294 \uacb0\uacfc\ub97c \ubc30\ub2ec\ud558\ub294 \ubc84\ud37c\uc5d0 \ub0b4\uc6a9\uc744 \uae08\ubc29 \ub2e4 \ucc44\uc6b8 \uc218 \uc788\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\uc870\uae08 \ub354 \uc27d\uac8c \uc0dd\ud65c\uc5d0 \ub9de\ucdb0\uc11c \uc124\uba85\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud648\uc1fc\ud551\uc5d0 \uc5ec\ud589\uc0c1\ud488\uc774 \uba87\uba85\uc774\uc0c1\uc774\uba74 \ucd9c\ubc1c\uc774\ub77c\ub294 \uac70 \ubcf4\uc2e0 \uc801 \uc788\uc73c\uc2dc\uc9c0\uc694?<\/p>\n\n\n\n<p>2\uba85\uc774\uc0c1 \ucd9c\ubc1c\uc5d0 \uac00\uaca9\uc774 \uc2f8\ub2e4\uba74 \uc774 \uc218\uc694\ub97c \uae08\ubc29 \ucc44\uc6b0\uace0 \uc5ec\ud589\uc744 \ub5a0\ub0a0 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc27d\uac8c \ub300\uc0c1\uc744 \ucc3e\uace0 \ubc14\ub85c \ub5a0\ub0a0 \uc218 \uc788\ub2e4\uba74 \uc774\ub97c \ubd80\ubd84\ubc94\uc704\ucc98\ub9ac\ub77c\uace0 \uc0dd\uac01\ud574\ub3c4 \ub420 \uac83 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub9cc\uc57d, \uc774\ub807\uac8c \uc218\uc694\ub97c \ub2e4 \ucc3e\uc740 \ub2e4\uc74c\uc5d0 \ud574\ub2f9\uc778\uc6d0\uc774 \ub2e4 \ubaa8\uc778 \ub2e4\uc74c\uc5d0 \uadf8 \uc548\uc5d0\uc11c \uacb0\ud63c\uc744 \ud574\uc11c \uc544\uc774\uac00 3\uba85 \uc788\ub294 \uc0ac\ub78c\ub9cc\uc744 \uc120\ubcc4\ud55c\ub2e4\uace0 \ud55c\ub2e4\uba74 \uc774 \uc5ec\ud589\uc744 \ub5a0\ub098\uae30 \ud798\ub4e4\uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc815\ub9ac\ud558\uc790\uba74, \ubd80\ubd84\ubc94\uc704\ucc98\ub9ac\ub77c\uace0 \ud558\uba74 \ub300\uc0c1\uc744 \uae08\ubc29 \ucc3e\uc544\uc11c \uacb0\uacfc\ubc84\ud37c\uc5d0 \ub300\uc0c1\uc744 \uae08\ubc29 \ucc44\uc6cc\uc11c \uacb0\uacfc\ub97c \ub0b4\ubcf4\ub0bc \uc218 \uc788\ub294 \uac83\uc774\ub77c\uace0 \ud55c\ub2e4\uba74, \uc804\uccb4\ubc94\uc704\ucc98\ub9ac\ub294 \ub300\uc0c1\uc744 \ucc3e\uc740 \ud6c4\uc5d0 \uc5b4\ub5a4 \uae30\uc900\uc73c\ub85c \ub2e4\uc2dc \uc815\ub82c\uc744 \ud558\ub294 \uac83\uc774\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \ub418\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc815\ub82c\uc774 \ub4e4\uc5b4\uac14\uc73c\ub2c8, \ub2f9\uc5f0\ud788 order by \ub294 \uc804\uccb4\ubc94\uc704\ucc98\ub9ac\ub97c \ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub610, group by \ub3c4 \uc5b4\ub5a4 \uae30\uc900\uc73c\ub85c \ubb36\ub294 \uac83\uc774\ub2c8\uae4c \uc774\ub3c4 \uc804\uccb4\ubc94\uc704\ucc98\ub9ac\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc790\uc8fc \uc4f0\uc2dc\ub294 Analytic Function ( rownumer() over (partition a, b order by a) ) \uc774\ub7f0 \uac83\ub3c4 \uc804\uccb4\ubc94\uc704\ucc98\ub9ac\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc704 \uadf8\ub9bc\uc5d0\uc11c \ube68\uac04 \ube14\ub7ed\uc73c\ub85c \ud45c\uc2dc\ub41c sort \uc5b4\uca4c\uace0 \ud558\ub294 \ubd80\ubd84\uc774\uc678\uc5d0\ub294 \uc804\ubd80 \uc77c\uce58\ud558\uc9c0 \uc54a\ub098\uc694?<\/p>\n\n\n\n<p>\uadf8 \ubd80\ubd84\uc744 \ubcf4\uc2dc\uba74 \uc544\uc2dc\uaca0\uc9c0\ub9cc, \uc800 \ubd80\ubd84\uc774 \uc804\uccb4\ubc94\uc704\ucc98\ub9ac\ub97c \ud558\uac8c \ub418\ub294 \uac83\uc774\ub77c\uace0 \ubcf4\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>full scan\uc774 \ub290\ub9b0 \uac83\uc774 \uc544\ub2c8\uace0, \uc804\uccb4\ubc94\uc704\ucc98\ub9ac\uac00 \ubd80\ubd84\ubc94\uc704\ucc98\ub9ac\uc5d0 \ube44\ud574\uc11c \ub2a6\ub2e4\ub77c\uace0 \uc774\ud574\ud558\uc154\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub098\uc911\uc5d0 \uc804\uccb4\ubc94\uc704\ucc98\ub9ac\ub97c \ud574\uc11c \ub354 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\ub294 \ubc29\ubc95\ub3c4 \uc874\uc7ac\ud569\ub2c8\ub2e4\ub9cc \uc9c0\uae08\uc740 \ub2e8\uc21c\ud558\uac8c \uc804\uccb4\ubc94\uc704\ucc98\ub9ac\uac00 \ubd80\ubd84\ubc94\uc704\ucc98\ub9ac\ubcf4\ub2e4 \ub2a6\ub2e4\ub77c\uace0 \uc774\ud574\ud558\uc2dc\ub294 \uac83\uc774 \uc815\uc2e0\uac74\uac15\uc5d0 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc804\uccb4\ubc94\uc704\ucc98\ub9ac\ub294 \ubb34\uc5c7\uc774\uace0, \ubd80\ubd84\ubc94\uc704\ucc98\ub9ac\ub294 \ubb34\uc5c7\uc778\uc9c0 \uc54c\uc544\ubcf4\ub3c4\ub85d \ud569\uc2dc\ub2e4. \uc544\uc8fc \uac04\ub2e8\ud558\uac8c \uc124\uba85\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc704 SQL\uc740 \uc804\uccb4\ubc94\uc704\ucc98\ub9ac\uc77c\uae4c\uc694? \uc804\uccb4\ub97c \ub300\uc0c1\uc73c\ub85c \ud558\ub2c8\uae4c \uc804\uccb4\ubc94\uc704\ucc98\ub9ac\uac00 \uc544\ub2d0\uae4c\uc694? \uc800\ub807\uac8c \ucffc\ub9ac\ub97c \uc791\uc131\ud558\uba74 \uacb0\uacfc\uac00 \ube68\ub9ac\ub098\uc624\ub098\uc694? \uc544\ub2c8\uba74 \ub2a6\uac8c \ub098\uc624\ub098\uc694? \uacb0\uacfc\uac00 \ube68\ub9ac \ub098\uc635\ub2c8\ub2e4. \uc774\uc720\ub294 \uacb0\uacfc\ub97c \ubc30\ub2ec\ud558\ub294 \ubc84\ud37c\uc5d0 \ub0b4\uc6a9\uc744 \uae08\ubc29 \ub2e4 \ucc44\uc6b8 \uc218 \uc788\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uc870\uae08 \ub354 \uc27d\uac8c \uc0dd\ud65c\uc5d0 \ub9de\ucdb0\uc11c \uc124\uba85\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud648\uc1fc\ud551\uc5d0 \uc5ec\ud589\uc0c1\ud488\uc774 \uba87\uba85\uc774\uc0c1\uc774\uba74 \ucd9c\ubc1c\uc774\ub77c\ub294 \uac70 \ubcf4\uc2e0 \uc801 \uc788\uc73c\uc2dc\uc9c0\uc694?\u2026 <span class=\"read-more\"><a href=\"https:\/\/sejiwon.com\/?p=364\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[10,1,8],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/364"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=364"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/364\/revisions"}],"predecessor-version":[{"id":366,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/364\/revisions\/366"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}