SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 06:30 PM
| ||||
| ||||
 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.c om... > > 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      |
Linear Mode
