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 vote209 views1 answer
Where database run
SQL
0 vote188 views1 answer
Select other columns with distinct
SQL
5 votes212 views1 answer
Invalid column name sql
SQL
1 vote193 views1 answer
Postgresql convert text to float
SQL
0 vote215 views1 answer
Helptext in sql
SQL
0 vote235 views1 answer
SQL Where-Klausel
SQL
0 vote201 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote189 views1 answer
How to get inserted id in sql server
SQL
0 vote207 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote217 views1 answer
Select even number id data from table
SQL