Discussion Locked

How to retrive 1000 rows at a time where table consists of 10000 rows.

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to retrive 1000 rows at a time (to be displayed)form the differnet tables where actual data consists of 10000 rows.SO guys does any one done any work around for this .please let me know

2 replies

by nikki96

With Oracle, you just do a select where rownum between two numbers. Note that rownum is probably Oracle specific, so check your DBMS documentation.

i.e.
select * from myTbl
where myField=3
and rownum between 10 and 20

by chellaganesh

If you are calling this query from a program, you need to pass the value for startval and end val.

where rownum between and

This discussion is closed to new replies.