select rownum rn,e.* from emp e;
查询emp表的信息,并显示行号
分页查询语句(结果集含有rn列)
select * from (select rownum rn,e.* from emp e) where rn between 2 and 10;
select rownum rn,e.* from emp e;
查询emp表的信息,并显示行号
分页查询语句(结果集含有rn列)
select * from (select rownum rn,e.* from emp e) where rn between 2 and 10;