Yexiong's java blog

Yexiong's java blog

ORACLE 下 SQL 分页

方法一:
select * from (select ROWNUM as rn, Src.* from tab Src) DataSet Where rn> 10 and rn< 20

方法二:
select * from (select ROWNUM as rn, Src.* from tab where rownum <= 150) where rn >= 100;

posted on 2005-05-31 13:38 Yexiong 阅读(1366) 评论(0)  编辑  收藏 所属分类: Database


只有注册用户登录后才能发表评论。


网站导航: