Oracle分页查询sql语句

1. select * from ( select  t.*, rownum RN from TABLE_NAME  t ) where RN > 0 and RN <= 15

2. select * from ( select  t.*, rownum RN from TABLE_NAME  t ) where RN between 1 and 15

posted @ 2016-07-21 13:59  如果屈原会编程  阅读(32396)  评论(0编辑  收藏  举报