Re: about selecting data from a table

You could also try

select IT.COL1, IT.COL2
  from (select rownum a, col1, col2 from YOUR_TABLE b where rownum <= HIGHROW#) IT
 where

      IT.rownum >= LOWROW#;

This will just cause the query to stop scanning YOUR_TABLE if it is really big. Suppose you had a million entries this would at least force the query to stop once it hit your upper limit.

HTH
Scott.

"Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> wrote in message news:9jom3o$4ij$1_at_news247.cnt.ru...
> Hello!
> Only for Oracle >=8.1
>
> select * from (select rownum a,b.* from YOUR_TABLE b) where a between 2500
> and 7500;
>
> Best regards!
> Yaroslav.
>
>
> Leader <sohelcsc_at_yahoo.com> ñîîáùèë â íîâîñòÿõ
> ñëåäóþùåå:b1a93c73.0107252137.3f4764d9_at_posting.google.com...
> > hi everybody,
> > i am facing a simple problem that is, suppose i want to retrieve data
> > from a table but not all data i just want to give from which row to
> > which row. suppose there are 10000 row in my table but i want to
> > retrieve from 2500 to 7500. what will be best solution of this.
> >
> > hoque
>
>
Received on Thu Jul 26 2001 - 13:42:32 CDT