Re: Selecting a range of records

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sun, 8 Jul 2001 17:20:01 +0100
Message-ID: <9ia13l$4m1$1@uranium.btinternet.com>

Use rownum

You can execute e.g. select * from emp where rownum between 10 and 30. Note that you will get an arbitrary set of 20 records!. To be more precise use order by.

--
Gerrit-Jan Linker
SQL*XL: addin for Excel for easy access to Oracle databases
http://www.oraxcel.com


<jabelsc_at_yahoo.com> wrote in message
news:3b442c77.179827625_at_news.ericsson.se...


>

> Hello everybody!

>

> I want to make a select of a table with a great amount of

> records and I only want to select only a range of them, for example,

> records between number 32 and 112.

>

> Is it posible to include a range in a select query in Oracle?

> I've heard that it's possible in Informix, I think.

>

> What I want to do with it is decrease the traffic between

> Oracle and a JSP application we have in different servers.

>

> Thanks.

>

> Abel S.

Received on Sun Jul 08 2001 - 11:20:01 CDT