Обсуждение: Select... RANGE?

I'm not finding any sample code that allows you to select a range in a
result set.

Let's say my query matches 500 records. I want it to return records 100-125.
I'm pretty sure I've seen this done, but I don't know where/how.

Tim