Skip records

[beth2000]

In select statment one can use "Fetch first 2000" to fetch first 2000 records in a table. Is there a way to fetch records 2001 to 4000 and so on. Is there a way to skip records. I know in MySQl one can do:

LIMIT 2001,4000


to fetch records 2001 to 4000.

I would appreciate any help in this matter.

Thanks

 

[MarcLodge]

HI Beth,
Graeme Birchall's great cookbook describes a technique of how to do this using olap functions. I've not tried this myself so can't comment but have a look at page 100 of the cookbook:

http://ourworld.compuserve.com/homepages/graeme_birchall/DB2V82CK.PDF

Regards,

Marc

 

[gregsimpson]

beth200,

I believe scrollable cursors, which came out in V7 do exactly what you require. May need some assitance from DBA in general db set up to allow them to work. Try this link for some high level info.

http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci1054848,00.html

Cheers
Greg