Pagination with row_number

DECLARE @Index INT;
DECLARE @PageSize INT;

SET @Index = 3;
SET @PageSize = 5;

SELECT *  FROM
  (SELECT  ROW_NUMBER() OVER (ORDER BY EmpID asc) as MyRowNumber,*
  FROM Employee) tblEmployee
WHERE MyRowNumber BETWEEN ( ((@Index - 1) * @PageSize )+ 1) AND @Index*@PageSize

Source: dba.stackexchange.com

Similar codes

103 votes302 views2 answers
Sql server LIKE '%%'
SQL
11 votes130 views1 answer
Sql insert multiple rows from select
SQL
1 vote114 views1 answer
What is intersect
SQL
5 votes102 views2 answers
Create table
SQL
0 vote115 views1 answer
Sql server get date of previous sunday
SQL
-1 vote121 views1 answer
Window functions in sql
SQL
0 vote118 views2 answers
How to know the character set of an oracle databes
SQL
0 vote140 views1 answer
Delete from table where length sql
SQL
0 vote119 views1 answer
Criteria builder select subset of column
SQL
14 votes112 views3 answers
How to add default constraint in mysql
SQL