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 vote130 views1 answer
Mysql get character set
SQL
0 vote138 views1 answer
Optimize sql query
SQL
0 vote131 views1 answer
Postgres call view
SQL
0 vote129 views1 answer
Sql database connectivity
SQL
1 vote141 views1 answer
Sql server list locks
SQL
10 votes260 views4 answers
Mysql if else
SQL
1 vote139 views1 answer
Oracle list constraints
SQL
5 votes157 views1 answer
Oracle nls parameters
SQL
1 vote139 views2 answers
Postgresql get difference in hours between two dates
SQL
59 votes326 views6 answers
Alter table sql
SQL