MySQL >>MS SQL transisiton problem.

[Arc]

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!!

[goatsucker]

I would think that if you need to do this and don't have a convenient field with which to limit your selection then you have your database design wrong.

Having said that you can use this kind of query to add a running total field

SELECT A.Field1, count(B.Field1)
FROM Table a, Table B
Where B.Field1 <= A.Field1
Group by A.Field1;

But this may be slow on large tables. you could then use this running total field to select on instead of the LIMIT function