B BmwHans1 Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-29 #1 我记得SQL SERVER好象有个TOP 选项，ORACLE有类似的吗，请指教！！！！
完 完颜康 Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-01 #2 select * from tablename where rownum<10
D dragontop Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-01 #4 first: select * from tablename where rownum<10 order by rowid next: select * from tablename where rownum>10
first: select * from tablename where rownum<10 order by rowid next: select * from tablename where rownum>10
B BmwHans1 Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-01 #5 dragontop>：你的方法和完颜康兄的是一回事，其实我的意思是说当数据量太大时， 我想分N次取出所有记录如何处理还请指教。
草 草央包包 Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-02 #6 select * from (select rownum rn,a.* from tablename a) b where rn between n*n1+1 and (n+1)*n1 n1是每次取的行数 n=0,1,2,3,4...
select * from (select rownum rn,a.* from tablename a) b where rn between n*n1+1 and (n+1)*n1 n1是每次取的行数 n=0,1,2,3,4...
A armyjiang Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-02 #7 感觉上如果楼主有这样的需求，应该用存储过程来实现，不能一直通过网络将数据都取到 客户端来！
小 小猪 Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-02 #8 草央包包的做法是正确的，oracle不支持rownum>??的条件。
