• <tfoot id='JUyil'></tfoot>
    <legend id='JUyil'><style id='JUyil'><dir id='JUyil'><q id='JUyil'></q></dir></style></legend>

  • <i id='JUyil'><tr id='JUyil'><dt id='JUyil'><q id='JUyil'><span id='JUyil'><b id='JUyil'><form id='JUyil'><ins id='JUyil'></ins><ul id='JUyil'></ul><sub id='JUyil'></sub></form><legend id='JUyil'></legend><bdo id='JUyil'><pre id='JUyil'><center id='JUyil'></center></pre></bdo></b><th id='JUyil'></th></span></q></dt></tr></i><div id='JUyil'><tfoot id='JUyil'></tfoot><dl id='JUyil'><fieldset id='JUyil'></fieldset></dl></div>

    <small id='JUyil'></small><noframes id='JUyil'>

      <bdo id='JUyil'></bdo><ul id='JUyil'></ul>

        在 SQL Server 中对结果进行分页的最佳方法是什么

        时间:2023-07-18

        • <bdo id='crLHy'></bdo><ul id='crLHy'></ul>
          <tfoot id='crLHy'></tfoot>

            1. <legend id='crLHy'><style id='crLHy'><dir id='crLHy'><q id='crLHy'></q></dir></style></legend>
                <tbody id='crLHy'></tbody>

                <small id='crLHy'></small><noframes id='crLHy'>

                • <i id='crLHy'><tr id='crLHy'><dt id='crLHy'><q id='crLHy'><span id='crLHy'><b id='crLHy'><form id='crLHy'><ins id='crLHy'></ins><ul id='crLHy'></ul><sub id='crLHy'></sub></form><legend id='crLHy'></legend><bdo id='crLHy'><pre id='crLHy'><center id='crLHy'></center></pre></bdo></b><th id='crLHy'></th></span></q></dt></tr></i><div id='crLHy'><tfoot id='crLHy'></tfoot><dl id='crLHy'><fieldset id='crLHy'></fieldset></dl></div>
                  本文介绍了在 SQL Server 中对结果进行分页的最佳方法是什么的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  如果您还想获得结果总数(分页前),在 SQL Server 2000、2005、2008、2012 中对结果进行分页的最佳方法(性能方面)是什么?

                  What is the best way (performance wise) to paginate results in SQL Server 2000, 2005, 2008, 2012 if you also want to get the total number of results (before paginating)?

                  推荐答案

                  获取结果总数和分页是两种不同的操作.为了这个例子,让我们假设你正在处理的查询是

                  Getting the total number of results and paginating are two different operations. For the sake of this example, let's assume that the query you're dealing with is

                  SELECT * FROM Orders WHERE OrderDate >= '1980-01-01' ORDER BY OrderDate
                  

                  在这种情况下,您将使用以下方法确定结果总数:

                  In this case, you would determine the total number of results using:

                  SELECT COUNT(*) FROM Orders WHERE OrderDate >= '1980-01-01'
                  

                  ...这可能看起来效率低下,但实际上非常高效,假设所有索引等都设置正确.

                  ...which may seem inefficient, but is actually pretty performant, assuming all indexes etc. are properly set up.

                  接下来,要以分页方式返回实际结果,以下查询将是最有效的:

                  Next, to get actual results back in a paged fashion, the following query would be most efficient:

                  SELECT  *
                  FROM    ( SELECT    ROW_NUMBER() OVER ( ORDER BY OrderDate ) AS RowNum, *
                            FROM      Orders
                            WHERE     OrderDate >= '1980-01-01'
                          ) AS RowConstrainedResult
                  WHERE   RowNum >= 1
                      AND RowNum < 20
                  ORDER BY RowNum
                  

                  这将返回原始查询的第 1-19 行.这里很酷的事情,特别是对于网络应用程序,你不必保留任何状态,除了要返回的行号.

                  This will return rows 1-19 of the original query. The cool thing here, especially for web apps, is that you don't have to keep any state, except the row numbers to be returned.

                  这篇关于在 SQL Server 中对结果进行分页的最佳方法是什么的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:将逗号分隔的值拆分为 Oracle 中的列 下一篇:Oracle SQL 数据透视查询

                  相关文章

                  <tfoot id='OdHUo'></tfoot>
                  1. <legend id='OdHUo'><style id='OdHUo'><dir id='OdHUo'><q id='OdHUo'></q></dir></style></legend>

                      <small id='OdHUo'></small><noframes id='OdHUo'>

                        <bdo id='OdHUo'></bdo><ul id='OdHUo'></ul>

                      <i id='OdHUo'><tr id='OdHUo'><dt id='OdHUo'><q id='OdHUo'><span id='OdHUo'><b id='OdHUo'><form id='OdHUo'><ins id='OdHUo'></ins><ul id='OdHUo'></ul><sub id='OdHUo'></sub></form><legend id='OdHUo'></legend><bdo id='OdHUo'><pre id='OdHUo'><center id='OdHUo'></center></pre></bdo></b><th id='OdHUo'></th></span></q></dt></tr></i><div id='OdHUo'><tfoot id='OdHUo'></tfoot><dl id='OdHUo'><fieldset id='OdHUo'></fieldset></dl></div>