一条SQL语句搞定Sql Server 2000 分页

适用2000/2005

SELECT TOP 页大小 *   
FROM table1   
WHERE id NOT IN   
          (   
          SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id   
          )   
ORDER BY id   

 适用2000/2005

SELECT TOP 页大小 *   
FROM table1   
WHERE id >  
          (   
          SELECT ISNULL(MAX(id),0)    
          FROM    
                (   
                SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id   
                ) A   
          )   
ORDER BY id   

 

适用2005

SELECT TOP 页大小 *    
FROM    
        (   
        SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* FROM table1   
        ) A   
WHERE RowNumber > 页大小*(页数-1)