//oracle 查询分页 sql语句1： select * from (select a.*, rownum rn from (select * from student) a) where rn between1 and 2; sql语句2（据说这种方法查询效率高，未验证）： select * from (select a.*,rownum rn from (select * from student where s
//oracle 查询分页
sql语句1：
select * from (select a.*, rownum rn from (select * from student) a) where rn
between 1 and 2;
sql语句2（据说这种方法查询效率高，未验证）：
select * from (select a.*,rownum rn from (select * from student where s_id between 5 and 9) a
where rownum=1
sql> select * from student;
s_id s_name s_age
-------------------------------------------------------------------------------- -------------------------------------------------- -----
1 potter 26
2 add 21
3 had 12
4 renee 15
5 reday 18
6 alisa 19
7 胡总 23
8 阿里山 29
9 扎西 20
10 香格里拉 24
11 琪琪格 28
12 暗夜精灵 19
12 rows selected
sql> select * from (select a.*, rownum rn from (select * from student) a) where rn between 2 and 4;
s_id s_name s_age rn
-------------------------------------------------------------------------------- -------------------------------------------------- ----- ----------
2 add 21 2
3 had 12 3
4 renee 15 4
sql> select * from (select a.*, rownum rn from (select * from student) a) where rn between 1 and 5;
s_id s_name s_age rn
-------------------------------------------------------------------------------- -------------------------------------------------- ----- ----------
1 potter 26 1
2 add 21 2
3 had 12 3
4 renee 15 4
5 reday 18 5
sql> select * from (select a.*, rownum rn from (select * from student) a) where rn between 1 and 10;
s_id s_name s_age rn
-------------------------------------------------------------------------------- -------------------------------------------------- ----- ----------
1 potter 26 1
2 add 21 2
3 had 12 3
4 renee 15 4
5 reday 18 5
6 alisa 19 6
7 胡总 23 7
8 阿里山 29 8
9 扎西 20 9
10 香格里拉 24 10
10 rows selected
sql> select * from (select a.*, rownum rn from (select * from student) a) where rn between 8 and 10;
s_id s_name s_age rn
-------------------------------------------------------------------------------- -------------------------------------------------- ----- ----------
8 阿里山 29 8
9 扎西 20 9
10 香格里拉