{"id":7547,"date":"2024-10-23T17:32:46","date_gmt":"2024-10-23T17:32:46","guid":{"rendered":"https:\/\/pohang.eduwp.kr\/?p=7547"},"modified":"2026-04-20T04:31:03","modified_gmt":"2026-04-20T04:31:03","slug":"9%ec%a3%bc%ec%b0%a8-%ec%84%b8%ea%b0%9c%ec%9d%98-%ed%85%8c%ec%9d%b4%eb%b8%94-%ec%a1%b0%ec%9d%b8%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/pohang.eduwp.kr\/?p=7547","title":{"rendered":"9\uc8fc\ucc28-2 \uc138\uac1c\uc758 \ud14c\uc774\ube14 \uc870\uc778\ud558\uae30, Having \uad6c\ubb38 \uc5f0\uc2b5"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\ubaa9\ucc28 \ud1a0\uae00\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/pohang.eduwp.kr\/?p=7547\/#%EC%84%B8%EA%B3%84%EC%9D%98_%ED%85%8C%EC%9D%B4%EB%B8%94_%EC%A1%B0%EC%9D%B8%ED%95%98%EA%B8%B0\" >\uc138\uacc4\uc758 \ud14c\uc774\ube14 \uc870\uc778\ud558\uae30<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/pohang.eduwp.kr\/?p=7547\/#%EB%8B%A4%EB%8C%80%EB%8B%A4_%EA%B4%80%EA%B3%84\" >\ub2e4\ub300\ub2e4 \uad00\uacc4<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/pohang.eduwp.kr\/?p=7547\/#HAVING_%EA%B5%AC%EB%AC%B8_%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0\" >HAVING \uad6c\ubb38 \uc0b4\ud3b4\ubcf4\uae30<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/pohang.eduwp.kr\/?p=7547\/#%EC%8B%A0%EA%B7%9C_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EB%B2%A0%EC%9D%B4%EC%8A%A4_%EB%A7%8C%EB%93%A4%EA%B8%B0\" >\uc2e0\uaddc \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \ub9cc\ub4e4\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/pohang.eduwp.kr\/?p=7547\/#having_%EC%A0%88%EC%9D%80_group_by_%EC%A0%88%EA%B3%BC_%ED%95%A8%EA%BB%98_%EC%82%AC%EC%9A%A9%ED%95%9C%EB%8B%A4\" >having \uc808\uc740 group by \uc808\uacfc \ud568\uaed8 \uc0ac\uc6a9\ud55c\ub2e4.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/pohang.eduwp.kr\/?p=7547\/#having_%EC%A0%88%EC%9D%80_%EC%A7%91%EA%B3%84%ED%95%A8%EC%88%98%EB%A5%BC_%EA%B0%80%EC%A7%80%EA%B3%A0_%EC%A1%B0%EA%B1%B4_%EB%B9%84%EA%B5%90%EB%A5%BC_%ED%95%A0_%EB%95%8C_%EC%82%AC%EC%9A%A9%ED%95%9C%EB%8B%A4\" >having \uc808\uc740 \uc9d1\uacc4\ud568\uc218\ub97c \uac00\uc9c0\uace0 \uc870\uac74 \ube44\uad50\ub97c \ud560 \ub54c \uc0ac\uc6a9\ud55c\ub2e4.<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%EC%84%B8%EA%B3%84%EC%9D%98_%ED%85%8C%EC%9D%B4%EB%B8%94_%EC%A1%B0%EC%9D%B8%ED%95%98%EA%B8%B0\"><\/span>\uc138\uacc4\uc758 \ud14c\uc774\ube14 \uc870\uc778\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<h2><span class=\"ez-toc-section\" id=\"%EB%8B%A4%EB%8C%80%EB%8B%A4_%EA%B4%80%EA%B3%84\"><\/span>\ub2e4\ub300\ub2e4 \uad00\uacc4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7548\" src=\"https:\/\/pohang.eduwp.kr\/wp-content\/uploads\/2024\/10\/20241024_022117.jpg\" alt=\"\" width=\"1047\" height=\"1267\" srcset=\"https:\/\/pohang.eduwp.kr\/wp-content\/uploads\/2024\/10\/20241024_022117.jpg 1047w, https:\/\/pohang.eduwp.kr\/wp-content\/uploads\/2024\/10\/20241024_022117-248x300.jpg 248w, https:\/\/pohang.eduwp.kr\/wp-content\/uploads\/2024\/10\/20241024_022117-846x1024.jpg 846w, https:\/\/pohang.eduwp.kr\/wp-content\/uploads\/2024\/10\/20241024_022117-768x929.jpg 768w\" sizes=\"auto, (max-width: 1047px) 100vw, 1047px\" \/><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">USE sqldb;\r\nCREATE TABLE stdtbl \r\n( stdName    VARCHAR(10) NOT NULL PRIMARY KEY,\r\n  addr\t  CHAR(4) NOT NULL\r\n);\r\nCREATE TABLE clubtbl \r\n( clubName    VARCHAR(10) NOT NULL PRIMARY KEY,\r\n  roomNo    CHAR(4) NOT NULL\r\n);\r\nCREATE TABLE stdclubtbl\r\n(  num int AUTO_INCREMENT NOT NULL PRIMARY KEY, \r\n   stdName    VARCHAR(10) NOT NULL,\r\n   clubName    VARCHAR(10) NOT NULL,\r\nFOREIGN KEY(stdName) REFERENCES stdtbl(stdName),\r\nFOREIGN KEY(clubName) REFERENCES clubtbl(clubName)\r\n);<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">INSERT INTO stdtbl VALUES ('\uae40\ubc94\uc218','\uacbd\ub0a8'), ('\uc131\uc2dc\uacbd','\uc11c\uc6b8'), ('\uc870\uc6a9\ud544','\uacbd\uae30'), ('\uc740\uc9c0\uc6d0','\uacbd\ubd81'),('\ubc14\ube44\ud0b4','\uc11c\uc6b8');\r\nINSERT INTO clubtbl VALUES ('\uc218\uc601','101\ud638'), ('\ubc14\ub451','102\ud638'), ('\ucd95\uad6c','103\ud638'), ('\ubd09\uc0ac','104\ud638');\r\nINSERT INTO stdclubtbl VALUES (NULL, '\uae40\ubc94\uc218','\ubc14\ub451'), (NULL,'\uae40\ubc94\uc218','\ucd95\uad6c'), (NULL,'\uc870\uc6a9\ud544','\ucd95\uad6c'), (NULL,'\uc740\uc9c0\uc6d0','\ucd95\uad6c'), (NULL,'\uc740\uc9c0\uc6d0','\ubd09\uc0ac'), (NULL,'\ubc14\ube44\ud0b4','\ubd09\uc0ac');\r\n<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">SELECT * from clubtbl;\r\nselect * from stdtbl;\r\nSELECT * from stdclubtbl;<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">-- 2\uac1c \uc870\uc778\r\nSELECT S.stdName, S.addr, SC.clubName\r\n   FROM stdtbl S \r\n      INNER JOIN stdclubtbl SC\r\n           ON S.stdName = SC.stdName\r\n   ORDER BY S.stdName;\r\n\r\n\r\n\r\n-- 3\uac1c \uc870\uc778\r\n\r\nSELECT S.stdName, S.addr, SC.clubName, C.roomNo\r\n   FROM stdtbl S \r\n      INNER JOIN stdclubtbl SC\r\n           ON S.stdName = SC.stdName\r\n      INNER JOIN clubtbl C\r\n           ON SC.clubName = C.clubName \r\n   ORDER BY S.stdName;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>3\uac1c \uc870\uc778 \ucd5c\uc885 \uc608\uc81c<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">SELECT S.stdName, S.addr, SC.clubName, C.roomNo\r\n   FROM stdtbl S \r\n      INNER JOIN stdclubtbl SC\r\n           ON S.stdName = SC.stdName\r\n      INNER JOIN clubtbl C\r\n           ON SC.clubName = C.clubName \r\n   ORDER BY S.stdName;\r\n  \r\nSELECT C.clubName, C.roomNo, S.stdName, S.addr\r\n   FROM  stdtbl S\r\n      INNER JOIN stdclubtbl SC\r\n         ON SC.stdName = S.stdName\r\n      INNER JOIN clubtbl C\r\n          ON SC.clubName = C.clubName\r\n    ORDER BY C.clubName;<\/pre>\n<p>&nbsp;<\/p>\n<h1><span class=\"ez-toc-section\" id=\"HAVING_%EA%B5%AC%EB%AC%B8_%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0\"><\/span>HAVING \uad6c\ubb38 \uc0b4\ud3b4\ubcf4\uae30<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<h2><span class=\"ez-toc-section\" id=\"%EC%8B%A0%EA%B7%9C_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EB%B2%A0%EC%9D%B4%EC%8A%A4_%EB%A7%8C%EB%93%A4%EA%B8%B0\"><\/span>\uc2e0\uaddc \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \ub9cc\ub4e4\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/pohang.eduwp.kr\/wp-content\/uploads\/2024\/10\/MYSQL_GMARKET.zip\">sql\ud30c\uc77c\ub2e4\uc6b4\ubc1b\uae30<\/a><\/p>\n<p>bestproducts \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131\ud558\uae30<\/p>\n<p>2\uac1c\uc758 sql \uad6c\ubb38\uc744 \uc2e4\ud589\ud574\uc11c \ub370\uc774\ud130\ub97c \ubaa8\ub450 \uc785\ub825<\/p>\n<hr \/>\n<h2><span class=\"ez-toc-section\" id=\"having_%EC%A0%88%EC%9D%80_group_by_%EC%A0%88%EA%B3%BC_%ED%95%A8%EA%BB%98_%EC%82%AC%EC%9A%A9%ED%95%9C%EB%8B%A4\"><\/span>having \uc808\uc740 group by \uc808\uacfc \ud568\uaed8 \uc0ac\uc6a9\ud55c\ub2e4.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"having_%EC%A0%88%EC%9D%80_%EC%A7%91%EA%B3%84%ED%95%A8%EC%88%98%EB%A5%BC_%EA%B0%80%EC%A7%80%EA%B3%A0_%EC%A1%B0%EA%B1%B4_%EB%B9%84%EA%B5%90%EB%A5%BC_%ED%95%A0_%EB%95%8C_%EC%82%AC%EC%9A%A9%ED%95%9C%EB%8B%A4\"><\/span>having \uc808\uc740 \uc9d1\uacc4\ud568\uc218\ub97c \uac00\uc9c0\uace0 \uc870\uac74 \ube44\uad50\ub97c \ud560 \ub54c \uc0ac\uc6a9\ud55c\ub2e4.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>gmarket\u00a0 \ud654\uba74\uacfc \ud14c\uc774\ube14 \uad6c\uc870 \uc0b4\ud3b4\ubcf4\uae30<\/p>\n<p>sum, avg , count \ub4f1\uc758 group by\uc640 \uc9d1\uacc4\ud568\uc218\ub294 wherer\uc640 \ud568\uaed8 \uc0ac\uc6a9\ud558\uc9c0 \ubabb\ud55c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>SELECT provider FROM items GROUP BY provider HAVING count(*) &gt;= 100;<\/p>\n<p>\uc5c5\uccb4 100\uac1c \ub97c \uc815\ub9ac\ud574\uc11c \ubcf4\uc5ec\uc918 \uad6c\ubb38<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">-- sum, avg , count \ub4f1\uc758 group by\uc640 \uc9d1\uacc4\ud568\uc218\ub294 wherer\uc640 \ud568\uaed8 \uc0ac\uc6a9\ud558\uc9c0 \ubabb\ud55c\ub2e4. \r\n-- \uc544\ub798 \ucf54\ub4dc\ub97c \ud55c\ubc88\uc529 \uc2e4\uc2b5\ud574\uc11c \uacb0\uacfc\ub97c \uccb4\ud06c\ud55c\ub2e4.\r\n\r\nSELECT provider, count(*) from items;\r\nSELECT provider FROM items WHERE count(*) &gt;= 100;\r\nSELECT provider, count(*) FROM items GROUP BY provider HAVING count(*) &gt;= 100;\r\n\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>\uc544\ub798 \ucf54\ub4dc \uc2e4\uc2b5\ud558\uae30<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">SELECT provider, count(*) from items;\r\nSELECT provider FROM items WHERE count(*) &gt;= 100;\r\nSELECT provider, count(*) FROM items GROUP BY provider HAVING count(*) &gt;= 100;<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc138\uacc4\uc758 \ud14c\uc774\ube14 \uc870\uc778\ud558\uae30 \ub2e4\ub300\ub2e4 \uad00\uacc4 USE sqldb; CREATE TABLE stdtbl ( stdName VARCHAR(10) NOT NULL PRIMARY KEY, addr CHAR(4) NOT NULL ); CREATE TABLE clubtbl ( clubName VARCHAR(10) NOT NULL&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[],"class_list":["post-7547","post","type-post","status-publish","format-standard","category-mysql"],"_links":{"self":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7547","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7547"}],"version-history":[{"count":5,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7547\/revisions"}],"predecessor-version":[{"id":7588,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7547\/revisions\/7588"}],"wp:attachment":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}