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

7 votes256 views1 answer
Append column sql
SQL
-1 vote351 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
1 vote244 views1 answer
Sql auto timestamp
SQL
0 vote258 views3 answers
Get count of null in column sql
SQL
6 votes257 views1 answer
Postgresql get year
SQL
0 vote282 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote280 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote245 views1 answer
Como leer datos de mysql esp32
SQL
2 votes250 views1 answer
Mysql auto increment jumping
SQL
1 vote266 views1 answer
Postgres get month name from date
SQL