{"id":625,"date":"2024-11-25T17:10:14","date_gmt":"2024-11-25T09:10:14","guid":{"rendered":"http:\/\/www.chan.ink\/?p=625"},"modified":"2024-11-25T17:10:17","modified_gmt":"2024-11-25T09:10:17","slug":"%e3%80%90mysql%e3%80%91where%e5%92%8chaving%e7%9a%84%e5%8c%ba%e5%88%ab","status":"publish","type":"post","link":"http:\/\/www.chan.ink\/index.php\/2024\/11\/25\/%e3%80%90mysql%e3%80%91where%e5%92%8chaving%e7%9a%84%e5%8c%ba%e5%88%ab\/","title":{"rendered":"\u3010MySQL\u3011where\u548chaving\u7684\u533a\u522b"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\"><strong>\u4ec0\u4e48\u65f6\u5019\u7528 <code>WHERE<\/code>\uff0c\u4ec0\u4e48\u65f6\u5019\u7528 <code>HAVING<\/code>\uff1f<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong><code>WHERE<\/code><\/strong>\uff1a\n<ul class=\"wp-block-list\">\n<li>\u7528\u4e8e\u5bf9\u539f\u59cb\u6570\u636e\u8fdb\u884c\u7b5b\u9009\u3002<\/li>\n\n\n\n<li>\u4e0d\u80fd\u4f7f\u7528\u805a\u5408\u51fd\u6570\u3002<\/li>\n\n\n\n<li>\u4f8b\uff1a\u7b5b\u9009\u5206\u6570\u5927\u4e8e 60 \u7684\u8bb0\u5f55\u3002sql\u590d\u5236\u4ee3\u7801<code>SELECT student_id, num FROM score WHERE num > 60;<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong><code>HAVING<\/code><\/strong>\uff1a\n<ul class=\"wp-block-list\">\n<li>\u7528\u4e8e\u5bf9\u5206\u7ec4\u540e\u7684\u6570\u636e\u8fdb\u884c\u7b5b\u9009\u3002<\/li>\n\n\n\n<li>\u53ef\u4ee5\u4f7f\u7528\u805a\u5408\u51fd\u6570\u3002<\/li>\n\n\n\n<li>\u4f8b\uff1a\u7b5b\u9009\u5e73\u5747\u5206\u5927\u4e8e 60 \u7684\u5b66\u751f\u3002sql\u590d\u5236\u4ee3\u7801<code>SELECT student_id, AVG(num) FROM score GROUP BY student_id HAVING AVG(num) > 60;<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u4ec0\u4e48\u65f6\u5019\u7528 WHERE\uff0c\u4ec0\u4e48\u65f6\u5019\u7528 HAVING\uff1f<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-625","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/posts\/625","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/comments?post=625"}],"version-history":[{"count":1,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/posts\/625\/revisions"}],"predecessor-version":[{"id":626,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/posts\/625\/revisions\/626"}],"wp:attachment":[{"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/media?parent=625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/categories?post=625"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/tags?post=625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}