MySQL LIMIT under MS SQL?

[earswithfeet]

Hi,

I'm currently trying to implement a simple sorting scheme a la MySQL LIMIT into a MS SQL query, but so far couldn't find a solution on the database end.

e.g.:
(MySQL) SELECT FROM test LIMIT 0,10
would be
(MS SQL) SELECT TOP 10 FROM test

but what would I have to use if I changed the start row to a different value than 0?
Is there no way in MS SQL to query for only a part of the database entries, so that I have to grab all queries and use php to sort out my needed rows?

e.g.:
(MySQL) SELECT * FROM test LIMIT 5,10
would be possible how in MS SQL?

[YappyDog]

The last time I used MS Sql the best you could do was limit the number of rows your query returned. But this was always from the start. There wasn't anyway to start part way in and then get a specific number of rows. Use the set zero option to reset things to normal after you are done.

SET ROWCOUNT 10
SELECT * FROM MSTable

SET ROWCOUNT 0

[mrhappiness]

seems like you need a subquery

SELECT
  TOP 10
  *
FROM 
  tablename
WHERE 
  keycolumn NOT IN
   (SELECT
    TOP 5
    keycolumn
    FROM tablename
    ORDER BY keycolumn)
ORDER BY
  keycolumn

try this