R: SQL Query : Fetch Next 10 rows

There was an example on iseriesnetwork that could be used by gci programs to retrieve records one page at a time:


n = number of records per page
p = number of page


SELECT * FROM
(SELECT * from
(SELECT * from Table /* where ...... */
ORDER BY aField ASC FETCH FIRST n*p ROWS ONLY) AS T1
ORDER BY aField DESC FETCH FIRST n ROWS ONLY) AS T2
ORDER BY aField




--- Mer 23/7/08, Srinivas Boggula <Srinivas.Boggula@xxxxxxxxx> ha scritto:

Da: Srinivas Boggula <Srinivas.Boggula@xxxxxxxxx>
Oggetto: SQL Query : Fetch Next 10 rows
A: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Data: Mercoledì 23 luglio 2008, 14:13
Hi All,

Each time when I run my query I need to fetch next 10 rows
from a
Physical File

Example: First Time 10 rows (i.e. 1 to 10 rows)
Second time another 10 rows (i.e. 11 records to 20
records)
Third Time another 10 rows (i.e 21 records
to 29
records) and so on....


I have tried with below query, but I'm confused how to
increment RRN
value dynamically

SELECT * FROM faplo WHERE RRN(faplo) >= 10 and
RRN(faplo) <= 20

Thanks in Advance


Regards,
Srinivas
iGATE is Ranked No. 3 in DQ-IDC best IT employer survey and
Ranked No.6
by Business Today-Mercer Human Resource Consulting-TNS in
a cross industry survey of Best Companies to work for in
India
----------------------------------------------------------------DISCLAIMER---------------------------------------------------------
Information transmitted by this EMAIL is proprietary to
iGATE Group of Companies and is intended for use only by
the individual
or entity to whom it is addressed and may contain
information that is privileged, confidential, or exempt
from disclosure under
applicable law. If you are not the intended recipient of
this EMAIL immediately notify the sender at iGATE or
mailadmin@xxxxxxxxx
and delete this EMAIL including any attachments

--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Posta, news, sport, oroscopo: tutto in una sola pagina.
Crea l&#39;home page che piace a te!
www.yahoo.it/latuapagina