摘要：--方法一：sql2000/2005SELECT TOP pagesize *FROM table1WHERE id > ( SELECT ISNULL(MAX(id),0) FROM ( SELECT TOP pagesize*(pageno-1) id FROM table1 ORDER BY id ) A )ORDER BY id--方法二DECLARE @pagenum AS INT, @pagesize AS INTSE... 阅读全文