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

2 votes309 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote287 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote305 views1 answer
Recently updated stored procedure in sql server
SQL
9 votes300 views3 answers
Mysql show table column full description
SQL
0 vote280 views1 answer
How to print records of employees hired in particular month in oracle
SQL
1 vote242 views1 answer
Restart identity postgresql
SQL
0 vote277 views2 answers
Azure sql-datenbank
SQL
0 vote275 views1 answer
Sql select most frequent value in group
SQL
0 vote292 views1 answer
Mysql type for large numbers with many decimal
SQL
16 votes295 views3 answers
Jwt secret key generator laravel
SQL