当前位置：Gxlcms > 数据库问题 > Oracle分页查询sql语句

Oracle分页查询sql语句

时间：2021-07-01 10:21:17 帮助过：2人阅读

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

Oracle分页查询sql语句

标签：

人气教程排行