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 vote114 views1 answer
Stuff in sql server
SQL
9 votes125 views6 answers
Sql insert into
SQL
3 votes153 views1 answer
Dbms_scheduler drop_job
SQL
1 vote134 views1 answer
Name of today sql
SQL
0 vote138 views1 answer
Mysql join column order By and group By
SQL
0 vote150 views1 answer
Mariadb used space
SQL
0 vote122 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
3 votes140 views1 answer
Select table column in sql
SQL
0 vote181 views1 answer
Mysql collation portugues brasil
SQL
0 vote136 views2 answers
Postgresql variable in query
SQL