i want to fetch first 5 rows and last 5 rows in a table?

babu_hi · New User Joined: 11 Apr 2006 Posts: 93

I have table that contain 50 rows,My requirement is i want fetch first 5 rows and last 5 rows in the table?

MFRASHEED · Active User Joined: 14 Jun 2005 Posts: 186 Location: USA

Try using CURSOR and FETCH options

refer to

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqj10/5.57?ACTION=MATCHES&REQUEST=fetch&TYPE=FUZZY&SHELF=&DT=20040216135741&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

Look for options like:

chettiyar · Posted: Wed Nov 22, 2006 12:24 pm

hi,
Thank u very much for porviding a good knowledge sharing topic.
Whether i need to specify these statements inside the declare cursor statement or any where else................................

special thanks to MFRASHEED

MFRASHEED · Active User Joined: 14 Jun 2005 Posts: 186 Location: USA

You would need to first declare CURSOR with 'WITH ROWSET POSITIONING'.

Refer to publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqj10/5.42?ACTION=MATCHES&REQUEST=CURSOR&TYPE=FUZZY&SHELF=&DT=20040216135741&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

and other statements to limit row selection will be part of actual FETCH statement. In earlier link i provided, page to then end and there are some good examples of FETCH.

I am glad i was able to help.

babu_hi · New User Joined: 11 Apr 2006 Posts: 93

Hi MFRASHEED,

Thanks for ur reply. i have executed this query it's working fine.

Regards
Babu