数据库分页

Oracle 和 sql server 2005 利用分析函数分页：

select * from(
select t1.*, row_number() over(order by t1.empno) as num
  from emp t1) t2
 where t2.num < 9
   and t2.num > 4;