offset and limit in mssql?

[mrdance]

In mysql you can specify the startposition of the result as the offset and limit as the number of rows to be returned. For example;

SELECT * FROM TABLE LIMIT $offset, $limit

How do I do it in MSSQL?

Thanks / Henrik

 

[Bernadette]

Hi There

To limit the amount of records returned in mssql you can
use the Top keyword.

To Select the top 10 records from a table
-----------------------------------------
Select Top 10 * From mytable


To Select the top 10 Percent of records from a table
----------------------------------------------------
Select Top 10 PERCENT * From mytable


I am not sure about the starting position .

Hope this helps
Bernadette