关于Oracle分页SQL

select u.*,rownum rn from users u
--以下语句无法排序
select * from(
select u.*,rownum rn from users u
order by u.userid
)
where rn between 1 and 10

--使用row_number函数重新生成伪列
select * from(
select u.*,row_number() over(order by u.userid) rn
from users u
)
where rn between 1 and 10

/*mysql
select * from users order by userid
limit 0,10

第一个参数是指要开始的地方，第二个参数是指每页显示多少条数据

*/