时间:2021-07-01 10:21:17 帮助过:6人阅读
//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<=3) where rn>=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 香格里拉