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

1 vote124 views1 answer
Mysql select month and year
SQL
1 vote150 views1 answer
Mysql dump specific tables
SQL
0 vote123 views1 answer
Delete * from where id = 1;
SQL
0 vote163 views1 answer
Oracle create package specification
SQL
0 vote156 views1 answer
Sql date with year
SQL
0 vote122 views1 answer
Report in database
SQL
0 vote196 views1 answer
Connect google bigquery connect using sqirrel
SQL
4 votes140 views1 answer
SQL find text in SP
SQL
8 votes119 views1 answer
Alter tablespace add datafile
SQL
7 votes97 views1 answer
Mysql load data infile csv
SQL