如何在 SQL Server 2000 中对结果进行服务器端分页? [英] How can I do server side pagination of results in SQL Server 2000?

问题描述

在 SQL Server 2005 中，有一个名为 row_number() 的功能，它使分页变得非常简单.

In SQL Server 2005, there is a feature called row_number() which makes pagination very simple.

SELECT * FROM table WHERE row_number() between x and y

在 SQL Server 2000 中是否有任何 SQL Server 方法可以做同样的事情?

Is there any SQL server way to do the same thing in SQL Server 2000?

(注意:我无法访问查询的唯一顺序编号，即可能是 row_number() 的同义词)

(Note: I don't have access to a unique sequential numbering for the query, i.e. something which would be a synonym for row_number())

推荐答案

SELECT  *
FROM    (
        SELECT  TOP (Y - X ) *
        FROM    (
                SELECT  TOP Y  *
                FROM    mytable
                ORDER BY
                        column
                ) q
        ORDER BY
                column DESC
        )
ORDER BY
        column

这篇关于如何在 SQL Server 2000 中对结果进行服务器端分页?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！