Oracle分页查询rownum与row_number() o

row_number() over()
...

select *
from (select *
      from (select b.*, row_number() over(order by bookid) as rownumber
              from (select * from book) b)
     where rownumber > 0)
 where rownum <= 8;

...

...

select *
from (select *
      from (select b.*, row_number() over(order by bookId) as rownumber
              from (select * from book) b))
 where rownumber >= 0  and  rownumber <= 10;

...

rownum

...

 select *
  from (select b.*, rownum as rn
      from (select * from book order by bookId) b
     where rownum <= 8)
  where rn > 0;

...

...

select *
from (select b.*, rownum as rn from (select * from book order by bookId) b)
 where rn >= 0 and rn <= 10;

...