select * from ( select REC.*,ROWNUM RN from (select t.* from table t)REC where ROWNUM <= num2 ) where RN >= num1
若果需要对结果集进行排序:可这样写,
select * from ( select REC.*,ROWNUM RN from (select t.* from table t order by condition(你的条件))REC where ROWNUM <= num2 ) where RN >= num1
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/208597.html原文链接:https://javaforall.net
