SQL paging statements in ORACLE

The following is a simple example of Several SQL paging statements in ORACLE. For more information, see.

The most common method is Method 1:

The Code is as follows:	Copy code
Select * from (select ROWNUM as rn, Src. * from tab Src) DataSet Where rn> 10 and rn <20 Method 2: Select * from (select ROWNUM as rn, Src. * from tab where rownum <= 150) where rn> = 100;

The result shows that the order by clause is executed after the statement becomes rownum, so the sorting result is not correct. I found an article on GOOGLE, it turns out that multiple select layers can effectively solve this problem. The statements are as follows:

The Code is as follows:	Copy code
Select * from (Select a. *, rownum row_num from (Select * from mytable t order by t. id desc) ) B where B. row_num between 1 and 10