Limit keyword

[Anon]

hi
I'm using php and mssql in a project .
I want to get the first 5th to 10th rows. how it is possible???
in mysql , limit keyword is present for that purpose.

I have a query for mysql

"select * from links where cat_id=1 order by title ASC limit 5, 10"

how can I use it for mssql???

thanks in advance
Mush

[znouza]

MS SQL knows "top" only..

so "select top 10 * from table"...