SELECT * FROM
(
SELECT A.*, rownum r
FROM
(
SELECT *
FROM Articles
ORDER BY PubTime DESC
) A
WHERE rownum <= PageUpperBound
) B
WHERE r > PageLowerBound;
Oracle分页新招
今天突然发现，Oracle原来可以这样实现分页功能：
select * from t_table where rowid not in(select rowid from t_table where rownum<=200) and rownum<=200
上述语句实现了从第201条记录开始处取200条记录
Trackback: http://tb.donews.net/TrackBack.aspx?PostId=514781