In MySQL you can use the limit function to return a subset of a query:

SELECT * FROM names LIMIT (5,15)

What's an easy way to do it in SQL Server? (I know somebody is going to say use top, as in SELECT TOP 10 * FROM names, but that gets the top 10, not items 5 through 15...) Any other suggestions?

Thanks!!