02 2011 档案

摘要：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 ; 阅读全文