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