Oracle数据分页

发表于 | 更新于:
字数统计: 53 | 阅读时长 ≈ 1

–这个速度稍微慢些

select * from  
(select m.*,rownum rn  
from (select * from music order by id) m)  
where rn between 11 and 20

–最好选择以下方式
select * from  
(select m.*,rownum rn  
from (select * from music order by id) m  
where rownum<=20) where="" rn="">=11

0%