Oracle分页的SQL语句基本上是通用的,通用语句如下:
分页语句:
select * from (select rownum r,a.* from qu_pilot_basic_info a where rownum<=20) where r>10;select
Oracle分页的SQL语句基本上是通用的,通用语句如下:
分页语句:
select * from (select rownum r,a.* from qu_pilot_basic_info a where rownum<=20) where r>10;select