{"id":1623,"date":"2011-03-23T00:43:19","date_gmt":"2011-03-23T00:43:19","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=1623"},"modified":"2011-03-23T00:43:19","modified_gmt":"2011-03-23T00:43:19","slug":"%e5%8f%96%e5%87%ba%e6%af%8f%e6%97%a5%e8%ae%a2%e5%8d%95%e6%9c%80%e5%a4%a7%e9%87%91%e9%a2%9d%e7%9a%84%e5%89%8d%e4%b8%89%e5%90%8drow_number","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2011\/03\/23\/%e5%8f%96%e5%87%ba%e6%af%8f%e6%97%a5%e8%ae%a2%e5%8d%95%e6%9c%80%e5%a4%a7%e9%87%91%e9%a2%9d%e7%9a%84%e5%89%8d%e4%b8%89%e5%90%8drow_number\/","title":{"rendered":"\u53d6\u51fa\u6bcf\u65e5\u8ba2\u5355\u6700\u5927\u91d1\u989d\u7684\u524d\u4e09\u540dROW_NUMBER"},"content":{"rendered":"<pre escaped=\"true\" lang=\"tsql\">\r\n 1,\u53d6\u51fa\u6240\u6709\u65e5\u671f\u4e2d\u8ba2\u5355\u6700\u5927\u91d1\u989d\u7684\u524d\u4e09\u540d\r\n  SELECT * FROM (\r\n    SELECT CONVERT(VARCHAR(10),bo.OrderDate,120) date1, orderno,amount,\r\n    ROW_NUMBER() OVER(ORDER BY bo.amount desc) AS numbers\r\n    FROM bdOrder bo(NOLOCK)\r\n    WHERE bo.OrderDate &gt;='2011-03-19'\r\n)m\r\nWHERE m.numbers &lt;=3\r\n2\uff0c\u82e5\u60f3\u53d6\u51fa\u6bcf\u65e5\u7684\u524d\u4e09\u540d\uff0c\u5c31\u9700\u8981\u5bf9\u6570\u636e\u8fdb\u884c\u6309\u65e5\u671f\u5206\u7ec4\uff0c\u4e0d\u80fd\u7528GROUP BY ,\u56e0\u4e3aOVER\u4e2d\u6709amount,\u5fc5\u987b\u8981\u5728GROUP BY \u4e2d\u52a0\u4e0aamount,\u4e5f\u6709\u5931\u53bb\u4e86\u5206\u7ec4\u7684\u610f\u5411\u3002\r\n    \u65b9\u6cd5\uff1a\u5728\u884c\u7ea7\u5206\u7ec4,\u5229\u7528\u5f3a\u5927\u7684OVER,\u5728\u884c\u7ea7\u5bf9\u65e5\u671f\u8fdb\u884c\u5206\u7ec4\r\n    SELECT * FROM (\r\n           SELECT CONVERT(VARCHAR(10),bo.OrderDate,120) date1, orderno,amount,\r\n           ROW_NUMBER() OVER(PARTITION BY CONVERT(VARCHAR(10),bo.OrderDate,120) ORDER BY bo.amount desc) AS numbers\r\n           FROM bdOrder bo(NOLOCK)\r\n           WHERE bo.OrderDate &gt;='2011-03-19'\r\n    )m\r\n     WHERE m.numbers &lt;=3<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1,\u53d6\u51fa\u6240\u6709\u65e5\u671f\u4e2d\u8ba2\u5355\u6700\u5927\u91d1\u989d\u7684\u524d\u4e09\u540d SELECT * FROM ( SELECT CONVERT(VARC [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-1623","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/1623","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=1623"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/1623\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=1623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=1623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=1623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}