Oracle分页
分页语句:
简单分页:select * from (select stu.*, rownum r from stu where rownum <=End) where r>Start;
先条件查询再分页:select * from (select stu.* ,rownum r from(select * from student order by score) stu where rownum <=End ) where r>Start;
分页参数:
Start:行记录的开始下标