分页技术

oracle分页技术: 采用row_number函数

 效率还不错

 

select num, sname from ( 
  select   ROW_NUMBER() OVER (ORDER BY sname) num, sname

  from    tb_student
   )  WHERE num BETWEEN 1 AND 23