sql2005/sql2008 分页

 SELECT  *  FROM 
 ( SELECT  ROW_NUMBER()  OVER  ( ORDER BY id )  AS RowNumber *  FROM Article ) 
 AS A1 --这里的as 一定要写,否则出错
 WHERE RowNumber BETWEEN  21 AND 30 ORDER BY id ;