Re: about selecting data from a table

From: Yaroslav Perventsev <p_yaroslav_at_cnt.ru>
Date: Thu, 26 Jul 2001 13:00:16 +0400
Message-ID: <9jom3o$4ij$1@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:00:16 CDT