This may be a little off topic, please forgive me. One of my webapplications
displays a group of results from a database query. These can be hundreds of
rows long. I would like to break these up into smaller sections to fit on a
page.
My problem is, I don't want to run the entire query at once and save it to
memory.
PostgreSQL and MySQL have the LIMIT num,offset qualifier which does exactly
what I want. The problem is that I'm using MS SQL and it doesn't use the
LIMIT keyword. Instead, it uses TOP and you can't supply an offset.
My quetion: Is there anyway to specify an offset into a query using MS SQL
Server? Thank you.
--min
