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

-1 vote195 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote204 views1 answer
Find wordpress version in database
SQL
12 votes171 views4 answers
Mysql version query
SQL
4 votes142 views1 answer
Sql list users and roles
SQL
0 vote167 views1 answer
Copy value from one column to another postgres
SQL
1 vote192 views4 answers
How to check table in postgresql from terminal
SQL
0 vote168 views1 answer
Mysql bash execute sql file
SQL
0 vote173 views1 answer
Sql shell psql cannot enter password
SQL
0 vote166 views1 answer
Select other columns with distinct
SQL
2 votes185 views1 answer
Oracle sql merge
SQL