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