Oracle分页可以通过下面两种方式
select * from ( select t.*, rownum RN from TABLE_NAME t ) where RN > 0 and RN <= 15`
select * from ( select t.*, rownum RN from TABLE_NAME t ) where RN between 1 and 15
MySQL分页使用
select * from table_name limit 9,4
Oracle分页可以通过下面两种方式
select * from ( select t.*, rownum RN from TABLE_NAME t ) where RN > 0 and RN <= 15`
select * from ( select t.*, rownum RN from TABLE_NAME t ) where RN between 1 and 15
MySQL分页使用
select * from table_name limit 9,4