{"id":167,"date":"2023-08-10T13:51:21","date_gmt":"2023-08-10T04:51:21","guid":{"rendered":"https:\/\/sejiwon.com\/?p=167"},"modified":"2023-08-10T13:51:58","modified_gmt":"2023-08-10T04:51:58","slug":"query-%ec%97%b0%ec%8a%b5","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=167","title":{"rendered":"Query \uc5f0\uc2b5 ( \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uce58\uc5c6\uc774 \ud558\ub294 \ubc95 )"},"content":{"rendered":"\n<p>Query\uc5f0\uc2b5\ud558\uae30 \uc704\ud574 \uaf2d \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc124\uce58\ud560 \ud544\uc694\uac00 \uc788\uc744\uae4c\uc694?<\/p>\n\n\n\n<p>\ubb3c\ub860, \uc774\uac83\uc744 \uc0dd\uc5c5\uc73c\ub85c \uc0b4\uc544\uac00\uae30 \uc704\ud574 \ubc30\uc6b4\ub2e4\uba74 Oracle, DB2, MySQL, postgreSQL\ub4f1\ub4f1 \ub9ce\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uce58\ubd80\ud130 \ubc30\uc6cc\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud558\uc9c0\ub9cc, \uac01 \ud68c\uc0ac\ub098 \ud559\uad50\ub4f1 \ub204\uad70\uac00 \uc124\uce58\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub9cc \uc774\uc6a9\ud558\ub824\uba74 Query\ub97c \uc791\uc131\ud558\uace0 \uc5f0\uc2b5\ud574\uc57c \ud558\ub294\ub370 \uc124\uce58\ud558\uace0 \ubb50\ud558\uace0 \ud558\ub2e4\uac00 \uc798 \uc124\uce58\uac00 \uc548\ub418\uae30\ub77c\ub3c4 \ud558\uba74 \uc791\uc131\ud558\uace0 \uc5f0\uc2b5\ud558\uae30 \uc804\uc5d0 \uc9c0\uccd0\uc11c \ud3ec\uae30\ud560 \uc218\ub3c4 \uc788\uace0, \ub108\ubb34 \ubaa9\ud45c\ub85c \uac00\uae30\uac00 \ud798\ub4e4\uc5b4\uc11c \ud765\ubbf8\ub97c \uc783\uc5b4\ubc84\ub9ac\uae30\ub3c4 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub0e5 Query\ub9cc \ubc30\uc6b0\uace0 \uc2f6\uc740\ub370, \uadf8 \ubaa8\ub4e0 \uc77c\ub4e4\uc744 \ub2e4 \ud560 \ud544\uc694\ub294 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub798\uc11c, \uc544\ub798 \uc0ac\uc774\ud2b8\uc5d0 \uc811\uc18d\ud574\uc11c \ubc14\ub85c Query\uc5f0\uc2b5\uc744 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.w3schools.com\/sql\/trysql.asp?filename=trysql_select_all\">https:\/\/www.w3schools.com\/sql\/trysql.asp?filename=trysql_select_all<\/a> <\/p>\n\n\n\n<p>\uc704 \uc0ac\uc774\ud2b8\uc5d0 \uc811\uc18d\ud558\uba74 \ubc14\ub85c Query \uc5f0\uc2b5\ud560 \uc218 \uc788\uc73c\uba70, \uc0ac\uc6a9\ubc95\uc740 \uac04\ub2e8\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"428\" src=\"https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/1-6-1024x428.png\" alt=\"\" class=\"wp-image-169\" srcset=\"https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/1-6-1024x428.png 1024w, https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/1-6-300x125.png 300w, https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/1-6-768x321.png 768w, https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/1-6-1536x642.png 1536w, https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/1-6-660x276.png 660w, https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/1-6.png 1884w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uc704\uc5d0 SQL Statement \uc5d0 Query\ub97c \uc785\ub825\ud558\uace0, Run SQL\uc744 \uc2e4\ud589\ud558\uba74 \uc544\ub798\uc640 \uac19\uc774 \uacb0\uacfc\uac00 \ub098\uc635\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"549\" src=\"https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/2-6-1024x549.png\" alt=\"\" class=\"wp-image-170\" srcset=\"https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/2-6-1024x549.png 1024w, https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/2-6-300x161.png 300w, https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/2-6-768x412.png 768w, https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/2-6-660x354.png 660w, https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/2-6.png 1531w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>\uc624\ub978\ucabd \uc704\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc740 \ud654\uba74\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"299\" height=\"310\" src=\"https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/3-5.png\" alt=\"\" class=\"wp-image-171\" srcset=\"https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/3-5.png 299w, https:\/\/sejiwon.com\/wp-content\/uploads\/2023\/08\/3-5-289x300.png 289w\" sizes=\"(max-width: 299px) 100vw, 299px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>\uac00\uc9c0\uace0 \uc788\ub294 Table Name\uacfc \uac01 Row\uc218\ub97c \uc54c \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud14c\uc774\ube14 \uc774\ub984\uc744 \ub204\ub974\uba74 \uacb0\uacfc\ucc3d\uc5d0 \ud14c\uc774\ube14 \ub0b4\uc6a9\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\ub7f0 \uc0ac\uc774\ud2b8\uac00 \uaf64 \ub9ce\uc774 \uc874\uc7ac\ud558\ub2c8 \ud55c\ubc88 \uc124\uce58\ud558\uc9c0 \uc54a\uace0 \uc0ac\uc6a9\ud558\uace0 \uc2f6\uc73c\uc2e0 \ubd84\ub4e4\uc740 \uc774\uc6a9\ud574 \ubcf4\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Query\uc5f0\uc2b5\ud558\uae30 \uc704\ud574 \uaf2d \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc124\uce58\ud560 \ud544\uc694\uac00 \uc788\uc744\uae4c\uc694? \ubb3c\ub860, \uc774\uac83\uc744 \uc0dd\uc5c5\uc73c\ub85c \uc0b4\uc544\uac00\uae30 \uc704\ud574 \ubc30\uc6b4\ub2e4\uba74 Oracle, DB2, MySQL, postgreSQL\ub4f1\ub4f1 \ub9ce\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uce58\ubd80\ud130 \ubc30\uc6cc\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc, \uac01 \ud68c\uc0ac\ub098 \ud559\uad50\ub4f1 \ub204\uad70\uac00 \uc124\uce58\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub9cc \uc774\uc6a9\ud558\ub824\uba74 Query\ub97c \uc791\uc131\ud558\uace0 \uc5f0\uc2b5\ud574\uc57c \ud558\ub294\ub370 \uc124\uce58\ud558\uace0 \ubb50\ud558\uace0 \ud558\ub2e4\uac00 \uc798 \uc124\uce58\uac00 \uc548\ub418\uae30\ub77c\ub3c4 \ud558\uba74 \uc791\uc131\ud558\uace0 \uc5f0\uc2b5\ud558\uae30 \uc804\uc5d0 \uc9c0\uccd0\uc11c \ud3ec\uae30\ud560 \uc218\ub3c4 \uc788\uace0, \ub108\ubb34 \ubaa9\ud45c\ub85c \uac00\uae30\uac00 \ud798\ub4e4\uc5b4\uc11c \ud765\ubbf8\ub97c\u2026 <span class=\"read-more\"><a href=\"https:\/\/sejiwon.com\/?p=167\">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":[8],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/167"}],"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=167"}],"version-history":[{"count":3,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/167\/revisions"}],"predecessor-version":[{"id":174,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/167\/revisions\/174"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}