--表结构 create table hy_emp( id number(4,0) primary key, name nvarchar2(20) not null, edate date) --充值 insert into hy_emp select rownum,dbms_random.string('*',dbms_random.value(1,20)),sysdate from dual connect by level<101 order by dbms_random.random --查所有数据 select * from hy_emp order by id --排序后加上伪列 select rownum as rn,a.* from (select * from hy_emp order by id) a --区间查询 select b.* from (select rownum as rn,a.* from (select * from hy_emp order by id) a ) b where b.rn>=10 and b.rn<=15 --与区间查询等效的minus查询 select b.* from (select rownum as rn,a.* from (select * from hy_emp order by id) a ) b where b.rn<=15 minus select b.* from (select rownum as rn,a.* from (select * from hy_emp order by id) a ) b where b.rn<10
--2020-04-02--