Re: about selecting data from a table

Hi,
just an adjustment for better performance:

select * from (select rownum a, b.* from YOUR_TABLE b where rownum < 7500) where a > 2500;

Ales

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 - 04:25:43 CDT