RE: SQL Query : Fetch Next 10 rows

[vhamberg@xxxxxxxxxxx]

There is no operation that will let you say - NEXT 10 - it would have no basis for it - how do you know where to start?

One suggestion is to capture the last set of values for each block - be sure to save something that is unique - then use a WHERE clause that has greater-than for that unique value

And then you can use the FETCH FIRST 10 ROWS ONLY clause along with it.
HTH
Vern

-------------- Original message -------------- 
From: "Srinivas Boggula" <Srinivas.Boggula@xxxxxxxxx> 

> But how do I retrieve next 10 records 
>
>
> -----Original Message----- 
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Walter 
> Sent: Wednesday, July 23, 2008 5:51 PM 
> To: Midrange Systems Technical Discussion 
> Subject: RE: SQL Query : Fetch Next 10 rows 
>
> Unless you've reorganized your file, RRN may not be accurate. 
>
> -----Original Message----- 
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Srinivas Boggula 
> Sent: Wednesday, July 23, 2008 8:04 AM 
> To: Midrange Systems Technical Discussion 
> Subject: SQL Query : Fetch Next 10 rows 
>
>
> 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 
> ----------------------------------------------------------------DISCLAIM 
> ER--------------------------------------------------------- 
> 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. 
>
>
> No virus found in this incoming message. 
> Checked by AVG - http://www.avg.com 
> Version: 8.0.138 / Virus Database: 270.5.5/1568 - Release Date: 
> 7/23/2008 6:55 AM 
> -- 
> 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. 
>
>
> 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.