There are vendor extensions for this, but unfortunately there isn't much consistency.
In Postgres (and MySQL IIRC) for example:
Would get you the top 10 from the resulting rows. In addition, you can add a second parameter to say which row to start with (offset):
In Access I believe you can do the following (note that I've never tried it):
However, getting a range is a little more complicated. One possibility is that you get, say, the top 100, then get the last 10 of those, in order to get results 90-100.
There are probably other approaches out there. Try searching for 'paging results' or similar, as it's essentially the same problem.
Hope this helps!