Paging in SQL Server

Question

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

possible duplicate of [Paging SQL Server 2005 Results](http://stackoverflow.com/questions/2840/paging-sql-server-2005-results) — , Aug 23 '10 at 11:34

score 0 · Answer 1 · answered Aug 23 '10 at 11:40

0

You can also use row_number()

answered Aug 23 '10 at 11:40

vaso

Dave Markle · Answer 2 · 2010-08-23T11:23:38.450

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

edited Aug 23 '10 at 11:23

answered Aug 23 '10 at 10:40

Dave Markle

2

This only gets the first page. You need to use the ROW_NUMBER function – Tim Rogers Aug 23 '10 at 10:41
Implicit in my answer was that you're keeping the last pagingID (650 in this case) and supplying it to the WHERE clause. Sorry if it was unclear. – Dave Markle Jan 09 '11 at 14:09

2 Answers2