{"id":60792,"date":"2020-04-08T08:34:14","date_gmt":"2020-04-08T00:34:14","guid":{"rendered":"http:\/\/4563.org\/?p=60792"},"modified":"2020-04-08T08:34:14","modified_gmt":"2020-04-08T00:34:14","slug":"8%e5%b9%b4%e8%80%81%e7%a8%8b%e5%ba%8f%e5%91%98%ef%bc%8c%e7%ab%9f%e7%84%b6%e5%86%99%e4%b8%8d%e5%87%ba%e8%bf%99%e4%b8%aasql%ef%bc%8c%e6%b1%82%e5%a4%a7%e4%bd%ac%e6%8c%87%e6%95%99%e3%80%82","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=60792","title":{"rendered":"8\u5e74\u8001\u7a0b\u5e8f\u5458\uff0c\u7adf\u7136\u5199\u4e0d\u51fa\u8fd9\u4e2asql\uff0c\u6c42\u5927\u4f6c\u6307\u6559\u3002"},"content":{"rendered":"\n

\t\t\t\t\t\u2660\u2663\u2665\u2764<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-3-22 11:44:36\t<\/p>\n

8\u5e74\u8001\u7a0b\u5e8f\u5458\uff0c\u7adf\u7136\u5199\u4e0d\u51fa\u8fd9\u4e2asql\uff0c\u6c42\u5927\u4f6c\u6307\u6559\u3002<\/h3>\n

\t\t \u672c\u5e16\u6700\u540e\u7531 \u2660\u2663\u2665\u2764 \u4e8e 2020-3-22 12:35 \u7f16\u8f91 <\/p>\n

\u7ed3\u679c\u96c6\u5982\u56fe\uff1a<\/p>\n

http:\/\/fastimg.info\/2020\/03\/22\/69b84f5ab00975e9be49903db3918bef.png<\/p>\n

\u9700\u6c42\uff1a \u6839\u636etype_name \u5206\u7ec4\uff0c\u6c42\u6bcf\u4e2a\u5206\u7ec4\u7684 \u524d5\u4e2a\u7ed3\u679c \u6309\u5206\u7ec4\u6392\u5e8f\u3002\u7ea2\u6846 \u5373\u4e3a\u9700\u6c42\u7ed3\u679c\u96c6\u3002
\u6392\u5e8f\u662f\u6309\u7167index \u540e\u9762\u7684 \u6570\u5b57\u6392\u5e8f\u7684\uff08index5 \u542b\uff0c\u4e4b\u524d\uff09\u3002\u4f46\u662f\u53c8\u4e0d\u65b9\u4fbf\u6bd4\u8f83\u5927\u5c0f\u3002<\/p>\n

\u8fd8\u662f\u81ea\u5df1\u6298\u817e\u51fa\u6765\u4e86\u3002<\/p>\n

SELECT source_listurl,type_name
FROM
    table1 AS a
WHERE
    (
      SELECT
            count(1)
      FROM
            table1 AS b
      WHERE
            a.type_name = b.type_name
      
      AND a.id > b.id
    ) < 5
ORDER BY
    a.id asc;\t\t\t\t<\/p>\n

\t\t\t\t\tJOSH<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-3-22 11:49:21\t<\/p>\n

<\/h3>\n

\t\t8\u5e74\u90fd\u5fd9\u7740\u770b\u5927\u59d0\u59d0~~\t\t\t\t<\/p>\n

\t\t\t\t\t\u4e00\u4e2a\u4e0d\u77e5\u540d\u7f51\u53cb<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-3-22 11:45:22\t<\/p>\n

<\/h3>\n

\t\t8\u5e74\u7a0b\u5e8f\u5458\u5199\u4e0d\u51fa\u8fd9\u4e2a\uff1f\t\t\t\t<\/p>\n

\t\t\t\t\t\u2660\u2663\u2665\u2764<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-3-22 11:46:39\t<\/p>\n

<\/h3>\n

\t\t\u4e00\u4e2a\u4e0d\u77e5\u540d\u7f51\u53cb \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-3-22 11:45
8\u5e74\u7a0b\u5e8f\u5458\u5199\u4e0d\u51fa\u8fd9\u4e2a\uff1f<\/p>\n

\u771f\u5199\u4e0d\u51fa\u3002\u3002\u3002\t\t\t\t<\/p>\n

\t\t\t\t\t\u2660\u2663\u2665\u2764<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-3-22 11:53:57\t<\/p>\n

<\/h3>\n

\t\tJOSH \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-3-22 11:49
8\u5e74\u90fd\u5fd9\u7740\u770b\u5927\u59d0\u59d0~~<\/p>\n

\u8fd9\u4e2a\u9700\u6c42\u770b\u8d77\u6765\u7b80\u5355\u3002\u5176\u5b9e\u8fd8\u662f\u9700\u8981\u529f\u5e95\u7684\u3002\t\t\t\t<\/p>\n

\t\t\t\t\tming997hk<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-3-22 11:57:14\t<\/p>\n

<\/h3>\n

\t\t\u3010SQL GROUP BY \u4e2d\u7684TOP N – \u8033\u4e1c\u4e4b\u4e95 – \u535a\u5ba2\u56ed\u3011https:\/\/**blogs.com\/chinshin\/articles\/3777476.html\t\t\t\t<\/p>\n

\t\t\t\t\tMr.<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-3-22 12:03:53\t<\/p>\n

<\/h3>\n

\t\t\u5de5\u4f5c\u5b66\u4e60\u4e868\u5e74\uff0c\u548c\u4e00\u5957\u6280\u80fd\u75288\u5e74\uff0c\u662f\u4e0d\u4e00\u6837\u7684\t\t\t\t<\/p>\n

\t\t\t\t\t\u2660\u2663\u2665\u2764<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-3-22 12:05:05\t<\/p>\n

<\/h3>\n

\t\tming997hk \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-3-22 11:57
\u3010SQL GROUP BY \u4e2d\u7684TOP N – \u8033\u4e1c\u4e4b\u4e95 – \u535a\u5ba2\u56ed\u3011https:\/\/**blogs.com\/chinshin\/articles\/3777476.html …<\/p>\n

\u6211\u8fd9\u4e2a\u8868\u91cc\u9762 \u6ca1\u6709\u4e00\u4e2a\u5217\u7684\u5b57\u6bb5\u53ef\u4ee5\u6bd4\u8f83\u5927\u5c0f \uff08\u6ca1\u6709age\u7c7b\u4f3c\u5b57\u6bb5\uff09\t\t\t\t<\/p>\n

\t\t\t\t\ttempuser2018<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-3-22 12:05:26\t<\/p>\n

<\/h3>\n

\t\t \u672c\u5e16\u6700\u540e\u7531 tempuser2018 \u4e8e 2020-3-22 12:23 \u7f16\u8f91 <\/p>\n

OVER (PARTITION BY ..) ?
https:\/\/blog.csdn.net\/fu0208\/article\/details\/7179001<\/p>\n

MySQL\u5b9e\u73b0
https:\/\/blog.csdn.net\/howie_zhw\/article\/details\/51706282 \t\t\t\t<\/p>\n

\t\t\t\t\tqixidi<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-3-22 12:08:23\t<\/p>\n

<\/h3>\n

\t\t\u80fd\u67e5\uff0c\u4f46\u662f\u590d\u6742\u4e00\u70b9\u3002\u9700\u8981\u4e48\t\t\t <\/p>\n","protected":false},"excerpt":{"rendered":"

\u2660\u2663\u2665\u2764 \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020…<\/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\/60792"}],"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=60792"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/60792\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=60792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=60792"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=60792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}