Paging in SQL Server

Question

How I can implement paging in SQL Server database it has no LIMT keyword like mysql?

Answer 1

It doesn't use LIMIT, but you can use TOP:

SELECT TOP 10 *
FROM foo
WHERE whateverPagingID >= 650 /* or whatever the last page started with */
ORDER BY pagingID;

Answer 2

Great article here

Answer 3

You can also use row_number()