Maison > base de données > tutoriel mysql > oracle 查询分页sql语句

oracle 查询分页sql语句

WBOY
Libérer: 2016-06-07 15:19:45
original
1810 Les gens l'ont consulté

//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                                                                               香格里拉    

 

 

 

Étiquettes associées:
source:php.cn
Déclaration de ce site Web
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn
Tutoriels populaires
Plus>
Derniers téléchargements
Plus>
effets Web
Code source du site Web
Matériel du site Web
Modèle frontal