SELECT * FROM
(
SELECT A.*, rownum r
FROM
(
/*SELECT *
FROM Articles
ORDER BY PubTime DESC*/
) A
WHERE rownum <= PageUpperBound
) B
WHERE r > PageLowerBound;
--注釋部分可換為任何sql語句
(
SELECT A.*, rownum r
FROM
(
/*SELECT *
FROM Articles
ORDER BY PubTime DESC*/
) A
WHERE rownum <= PageUpperBound
) B
WHERE r > PageLowerBound;
--注釋部分可換為任何sql語句