在使用中,不能直接用between and 来对rownum限制,只能先把rownum 重命名后才能:
SELECT * FROM
(SELECT a.* ,a.ppid AS abc,ROWNUM AS rs FROM
(SELECT * FROM gj_pp a ORDER BY ppid) a
) b
WHERE b.rs BETWEEN 3 AND 9
并且rownum在表的搜索时期已经确定,所以order by 会把它打乱。解决方案时在搜索到所需数据后,先order by,然后再用一个select把rownum加上去,最后在再加一个select,用between and 限制rownum