{"id":1423,"date":"2010-11-25T09:11:34","date_gmt":"2010-11-25T09:11:34","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=1423"},"modified":"2010-11-25T09:12:32","modified_gmt":"2010-11-25T09:12:32","slug":"sqlserver%e7%9a%84limit%e5%ae%9e%e7%8e%b0-row_number%ef%bc%88%ef%bc%89","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2010\/11\/25\/sqlserver%e7%9a%84limit%e5%ae%9e%e7%8e%b0-row_number%ef%bc%88%ef%bc%89\/","title":{"rendered":"SqlServer\u7684limit\u5b9e\u73b0-ROW_NUMBER\uff08\uff09"},"content":{"rendered":"<pre lang=\"tsql\">\r\n \u4e3a\u7ed3\u679c\u96c6\u6784\u9020\u884c\u53f7\uff0c\u5b9e\u9645\u4e0a\u662f\u4e3a\u7ed3\u679c\u96c6\u6307\u5b9a\u987a\u5e8f\uff0c\u8981\u6392\u5e8f\u7684\u8bdd\u5c31\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\uff1aOrder By\r\n\u5982\uff1aSELECT ROW_NUMBER() OVER(ORDER BY id DESC)AS rownum,\r\n       departname  FROM mdDepartment md\r\n\u5e94\u7528\uff1amysql\u7684limit\u5373\u53ef\u4f7f\u7528\uff1a\r\nSELECT * FROM\r\n(\r\nSELECT ROW_NUMBER() OVER(ORDER BY id DESC)AS rownum,departname\r\nFROM mdDepartment md\r\n) AS a\r\nWHERE a.rownum>=3 AND a.rownum<=5      --\u8fd4\u56de3\u52305\u884c\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4e3a\u7ed3\u679c\u96c6\u6784\u9020\u884c\u53f7\uff0c\u5b9e\u9645\u4e0a\u662f\u4e3a\u7ed3\u679c\u96c6\u6307\u5b9a\u987a\u5e8f\uff0c\u8981\u6392\u5e8f\u7684\u8bdd\u5c31\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\uff1aOrder By \u5982\uff1aSELECT R [&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-1423","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\/1423","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=1423"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/1423\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=1423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=1423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=1423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}