Yexiong's java blog
方法一：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 閱讀(1371) 評論(0) 編輯 收藏 所屬分類: Database
Powered by: BlogJava Copyright © Yexiong