Re: Selecting a range of records

<jabelsc_at_yahoo.com> wrote in message
news:3b442c94.179856890_at_news.ericsson.se...

> 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.

for example:

select * from (
  select <blah>,rownum as ROW_NUMB from <table>) where ROW_NUMB between 32 and 112

regards, Dmitry. Received on Thu Jul 05 2001 - 11:40:09 CEST