Oracle认证辅导:Oracle分页语句Oracle认证考试

文章作者 100test 发表时间 2010:03:11 19:01:07
来源 100Test.Com百考试题网

　　page size :3

　　page number: 2

　　需要考虑order by 的情况：

　　0select s.* from

　　(

　　0select rownum as rn,c.*

　　from (0select * from tableName order by columnName desc) c

　　) s

　　where s.rn between 3*(2-1) 1 and 2*3.

　　0select * from

　　(

　　0select rownum as rn,c.*

　　from (0select * from tableName order by columnName asc) c

　　where rownum