方法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)