RE: piece-wise return of records from table

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 22 Jul 2003 17:58:41 -0700
Message-Id: <25988.338998@fatcity.com>

I guess it wouldn't hurt to include Mr. Kyte's answer: select *
  from ( select a.*, rownum rnum

           from ( YOUR_QUERY_GOES_HERE -- including the order by ) a
          where rownum <= MAX_ROWS )

 where rnum >= MIN_ROWS
/

He demonstrates on the site why this is the best solution.

> -----Original Message-----
> From: Jacques Kilchoer
>
> Tom Kyte to the rescue!
> getting rows N through M of a result set
> http://asktom.oracle.com/pls/ask/f?p=4950:8:::NO::F4950_P8_DIS
PLAYID,F4950_P8_CRITERIA:127412348064,
or
http://tinyurl.com/hqsl

(You can ignore the little argument on that page where Mr. Kyte lays down the law about not using abbreviations like "u r" for "you are".)

-----Original Message-----
From: VIVEK_SHARMA [mailto:VIVEK_SHARMA_at_infosys.com]

CASE select * from table gives 1000 records (say) We want only first ten of these records to be returned to the front end & then records 11 to 20 & so on ...

How may the above be optimally possible ? Received on Tue Jul 22 2003 - 19:58:41 CDT