找按升序排列后的指定位置数据，比如只要第10个到第20个,该如何解决

找按升序排列后的指定位置数据，比如只要第10个到第20个
oracle中表
create table dml.allcaseinfo(
allcasenumNUMBER primary key, 
casenum NUMBER,
historynumNUMBER
);
想实现查找按allcasenum升序排列后的指定第几个，比如只要第10个到第20个




[解决办法]
select *
from (
select t.*, rownum rn
from (
select * from dml.allcaseinfo order by allcasenum asc
) t
 where rn <= 20
)
 where rn >= 10

[解决办法]

SQL code

select *  from (select emp.*, rownum r from emp where rownum < 21 order by empno) where r > 9;
[解决办法]
oracle中表
create table dml.allcaseinfo(
allcasenum NUMBER primary key, 
casenum NUMBER,
historynum NUMBER
);
想实现查找按allcasenum升序排列后的指定第几个，比如只要第10个到第20个

SQL code
select * from (select a.*,rownum rn from (select * from dml.allcaseinfo order by allcasenum asc) a)twhere rn between 10 and 20