Thread: How to retrieve first 50 rows , next 50 rows and so on in Informix
View Single Post

   
  #4 (permalink)  
Old 04-19-2008, 06:31 PM
John Carlson
 
Posts: n/a
Default Re: How to retrieve first 50 rows , next 50 rows and so on in Informix
On 25 Aug 2003 14:27:45 -0700, kalpanapai@hotmail.com (KalpanaPai)
wrote:

>I know that
>Select first 50* from Table will get only 50 rows
>But i want to know from the application side , if the query returns
>more rows , i want to get them in 50's and display and next 50 etc, in
>that way the query will not kill the memory if more sessions are
>connected without bringing the whole data to the buffer .
>

What application / development language are you using?
Reply With Quote