如何用sql语句 实现分页查询？

Question

如何用sql语句 实现分页查询？

Answer 1

方法1：适用于 SQL Server 2000/2005SELECT TOP 页大小 *FROM table1WHERE id NOT IN(SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id)ORDER BY id方法2：适用于 SQL Server 2000/2005SELECT TOP 页大小 *FROM table1WHERE id >(SELECT ISNULL(MAX(id),0)FROM(SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id) A)ORDER BY id方法3：适用于 SQL Server 2005SELECT TOP 页大小 *FROM(SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* FROM table1) AWHERE RowNumber > 页大小*(页数-1)