{"id":97,"date":"2019-06-21T09:37:33","date_gmt":"2019-06-21T01:37:33","guid":{"rendered":"http:\/\/www.cgh0610.cn\/?p=97"},"modified":"2019-06-21T09:39:26","modified_gmt":"2019-06-21T01:39:26","slug":"mysql-having%e7%94%a8%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.cgh0610.cn\/?p=97","title":{"rendered":"MySql having\u7528\u6cd5"},"content":{"rendered":"<p>Mysql\u4e2d\uff0cwhere\u662f\u805a\u5408\u524d\u7b5b\u9009\u6761\u4ef6\uff0c\u7528\u4e8e\u884c\u5217\u6570\u636e\u8fdb\u5165\uff0c\u4e0d\u53ef\u7ed3\u5408\u51fd\u6570\u4f7f\u7528\uff1b\u800chaving\u5219\u662f\u7528\u4e8e\u805a\u5408\u540e\u6570\u636e\u7684\u7b5b\u9009\uff0c\u53ef\u4ee5\u63a5\u5408\u51fd\u6570\u4f7f\u7528,\u4e00\u822chaving \u8ddf\u5728group by\u540e\u9762\u4f7f\u7528\u3002<br \/>\n\u4ee5\u4e0b\u662f\u5b9e\u9645\u4f7f\u7528\uff1a<br \/>\n\u627e\u51faperson\u8868\u4e2d\u91cd\u590d\u7684\u90ae\u7bb1<\/p>\n<pre><code class=\"language-php line-numbers\">#\u65b9\u6cd51 \u4f7f\u7528\u4e34\u65f6\u8868 \u8bed\u53e5\u6bd4\u8f83\u590d\u6742\nselect s.email from (\n    select email,count(email) as num from person group by email \n) as s \nwhere s.num&gt;1\n<\/code><\/pre>\n<pre><code class=\"language-php line-numbers\">#\u65b9\u6cd52 \u4f7f\u7528having\nselect email from person group by email having count(email)&gt;1\n\n#\u6ce8\u610fhaving\u5c5e\u4e8e\u805a\u5408\u540e\u7b5b\u9009\uff0c\u5e94\u5728where\u540e\uff0c\u4e14\u653e\u7f6e\u4e8eorder by\u540e\u9762\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Mysql\u4e2d\uff0cwhere\u662f\u805a\u5408\u524d\u7b5b\u9009\u6761\u4ef6\uff0c\u7528\u4e8e\u884c\u5217\u6570\u636e\u8fdb\u5165\uff0c\u4e0d\u53ef\u7ed3\u5408\u51fd\u6570\u4f7f\u7528\uff1b\u800chaving\u5219\u662f\u7528\u4e8e\u805a\u5408\u540e\u6570\u636e &hellip; <a href=\"https:\/\/www.cgh0610.cn\/?p=97\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">MySql having\u7528\u6cd5<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"aside","meta":[],"categories":[39,12],"tags":[41,40,28,42],"_links":{"self":[{"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/posts\/97"}],"collection":[{"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=97"}],"version-history":[{"count":2,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/posts\/97\/revisions"}],"predecessor-version":[{"id":100,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/posts\/97\/revisions\/100"}],"wp:attachment":[{"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=97"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=97"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=97"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}