Re: How to retrieve first 50 rows , next 50 rows and so on in Informix
Something like:
Select first 50 Table.* fron Table
/Arthur
----- Original Message -----
From: Danny De Koster <ddk@fidelity-soft.be>
To: <informix-list@iiug.org>
Sent: Monday, August 25, 2003 11:22 AM
Subject: Re: How to retrieve first 50 rows , next 50 rows and so on in
Informix
> Hi,
>
> You could declare a scroll cursor.
> Using a counter you could fetch the first 50 records, doing a fetch next
and
> increase the counter
> until 50 records are read.
> But it would be nicer to limit the number of selected rows.
> For example: select first 50...., select next 50...., select previous
50....
> Is this possible?
>
> Danny
>
>
> "KalpanaPai" <kalpanapai@hotmail.com> wrote in message
> news:8b77f6f5.0308241906.21eb6f22@posting.google.com...
> > Hi All
> >
> > Is there any equivalent command for SET ROWCOUNT or LIMIT in INFORMIX
> > to get the first 50rows, next 50 rows and so on if query returns 2500
> > rows .
> >
> > So that the number of rows retrived for each page can be limited in
> > each session.
> >
> > Any clues would be appreciated.
> > Thanks in Advance
> > Kalpana
>
>
>
sending to informix-list