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

0 vote282 views1 answer
Mysql join only one column
SQL
0 vote258 views1 answer
Downgrading sql localdb visual studio
SQL
1 vote270 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
2 votes266 views5 answers
Alter table primary key postgresql
SQL
0 vote305 views1 answer
Select the date 30 days less that the todays date sql request
SQL
1 vote293 views1 answer
Oracle compile schema
SQL
-1 vote305 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote269 views1 answer
Sql server inner join convert collation
SQL
0 vote291 views1 answer
Limit in access query
SQL
1 vote219 views1 answer
Postgres reset auto increment
SQL