{"id":127824,"date":"2020-06-06T03:27:28","date_gmt":"2020-06-05T19:27:28","guid":{"rendered":"http:\/\/4563.org\/?p=127824"},"modified":"2020-06-06T03:27:28","modified_gmt":"2020-06-05T19:27:28","slug":"%e7%b1%bb%e4%bc%bc%e8%bf%99%e6%a0%b7%e7%9a%84%e6%9f%a5%e8%af%a2%e8%af%ad%e5%8f%a5%ef%bc%8c%e5%a6%82%e6%9e%9c%e5%bb%ba%e7%b4%a2%e5%bc%95%e8%83%bd%e8%ae%a9-sql-%e5%8f%98%e5%be%97%e9%ab%98%e6%95%88","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=127824","title":{"rendered":"\u7c7b\u4f3c\u8fd9\u6837\u7684\u67e5\u8be2\u8bed\u53e5\uff0c\u5982\u679c\u5efa\u7d22\u5f15\u80fd\u8ba9 sql \u53d8\u5f97\u9ad8\u6548\uff0c\u5927\u795e\u6c42\u89e3\uff01"},"content":{"rendered":"<div>\n<div>\n<div>\n<h1>                  \u7c7b\u4f3c\u8fd9\u6837\u7684\u67e5\u8be2\u8bed\u53e5\uff0c\u5982\u679c\u5efa\u7d22\u5f15\u80fd\u8ba9 sql \u53d8\u5f97\u9ad8\u6548\uff0c\u5927\u795e\u6c42\u89e3\uff01               <\/h1>\n<p> <\/p>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : 243634473 <\/span>  <span><i><\/i> 4<\/span> <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div isfirst=\"1\"> <\/p>\n<p>SELECT id,title,date,type_id FROM table WHERE title=&#8217;v2ex&#8217; GROUP BY type_id ORDER BY date DESC LIMIT 10;<\/p>\n<\/p><\/div>\n<div> <b>\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (<span>1<\/span>)        <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<ul>\n<li data-pid=\"2155406\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : xiangyuecn <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4e0d\u5728 group by \u91cc\u9762\u7684\u5b57\u6bb5\u80fd\u5728\u4e00\u4e2a\u67e5\u8be2\u91cc\u9762\u67e5\u8be2\u51fa\u6765\uff1f<\/p>\n<p>\u65e0\u8111\u5efa\u590d\u5408\u7d22\u5f15\uff1a<br \/>1. where \u6761\u4ef6\u5b57\u6bb5\u6392\u524d\u9762\uff0c\u5185\u5bb9\u8d8a\u79bb\u6563\u7684\u8d8a\u6392\u524d\u9762<br \/>2. group \u6761\u4ef6\u5b57\u6bb5\u6392\u4e2d\u95f4\uff0c\u6309 group \u987a\u5e8f<br \/>3. order \u5b57\u6bb5\u6392\u540e\u9762\uff0corder \u5c31\u7b97\u4e0a\u4e86\u7d22\u5f15\u91cc\u9762\uff0c\u590d\u6742\u6761\u4ef6\u4e0b\u5bf9\u6392\u5e8f\u76ee\u6d4b\u5f88\u96be\u8d77\u5230\u4f5c\u7528\uff0c\u4e0d\u8fc7\u5728\u7d22\u5f15\u4e2d\u907f\u514d\u989d\u5916\u8bfb\u76d8\u8fd8\u662f\u86ee\u5b9e\u7528<\/p>\n<p>end.                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li>\n","protected":false},"excerpt":{"rendered":"<p>\u7c7b\u4f3c\u8fd9\u6837\u7684\u67e5\u8be2\u8bed\u53e5\uff0c\u5982\u679c\u5efa\u7d22\u5f15\u80fd\u8ba9&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/127824"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=127824"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/127824\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=127824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=127824"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=127824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}