What is other way of use Limit function in SQL Server

Question

How to use LIMIT function in SQL Server?

I need to create a pagination using SQL Server data and I need to fetch the data using $start and $pagesize.

This is the query used:

  SELECT * 
  FROM Customers 
  LIMIT $start, $pagesize;

be sure to look at answer 1 and 2 in the link in comment above — James Anderson, Jul 21 '15 at 11:44
Related question: [How does paging work with ROW_NUMBER in SQL Server?](http://dba.stackexchange.com/questions/32884/how-does-paging-work-with-row-number-in-sql-server) — ypercubeᵀᴹ, Jul 21 '15 at 12:10

score 0 · Accepted Answer · answered Jul 25 '15 at 05:06

0

use this query

select * from (
SELECT  *,ROW_NUMBER() OVER ( ORDER BY az135 desc ) AS RowNum
FROM    ( SELECT     az13 FROM a12 WHERE   (az133 = '**') ) AS RowConstrainedResult )as a WHERE   RowNum >= 10 AND RowNum <= 20

answered Jul 25 '15 at 05:06

user1667845

57
1
10

What is other way of use Limit function in SQL Server

1 Answers1