分页

SqlServer:：

select top @pagesize * from table1 where id not in (select top @pagesize*(@page-1) id from table1 order by id) order by id

Oracle：
SELECT * FROM
     (
     SELECT A.*, rownum r
     FROM
          (
          SELECT *
          FROM Articles
          ORDER BY PubTime DESC
          ) A
     WHERE rownum <= PageUpperBound
     ) B
WHERE r > PageLowerBound;