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 vote301 views1 answer
How to reset the database value in SQL server
SQL
0 vote287 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote289 views2 answers
Close external port 3306 with iptables
SQL
11 votes302 views5 answers
Sql server reset identity
SQL
11 votes316 views3 answers
Python sqlite3 create table if not exists
SQL
6 votes301 views2 answers
Postgresql restore from dump
SQL
0 vote273 views1 answer
Minecraft duping allowed servers
SQL
0 vote283 views1 answer
Mysql_error replacement
SQL
0 vote278 views1 answer
Mysql remove tabs from string
SQL
3 votes307 views2 answers
How to delete git repo locally
SQL