oracle 数据分页

 select * from (select rownum as num,emp.* from emp)
   where num >= 9 and num <= 12;

posted @ 2009-08-13 10:03  左少白  阅读(182)  评论(0)  编辑  收藏  举报