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

4 votes354 views2 answers
Sql select except null
SQL
0 vote359 views1 answer
Raiserror with nowait
SQL
0 vote327 views0 answer
SQL
0 vote356 views1 answer
Sql server convert to guid
SQL
0 vote340 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
5 votes352 views1 answer
JBDC
SQL
1 vote344 views1 answer
Postgres concat_ws
SQL
0 vote359 views1 answer
Mysql insert into select transaction c#
SQL
0 vote342 views1 answer
Mariadb mysql root access denied
SQL
0 vote337 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL