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

16 votes136 views4 answers
Sort by sql
SQL
1 vote157 views1 answer
Quit mysql
SQL
0 vote150 views1 answer
T sql return on letters only
SQL
0 vote191 views1 answer
Sql alter table add column if exists
SQL
2 votes152 views3 answers
Row number mysql
SQL
0 vote133 views1 answer
Alter table add foreign key mariadb example
SQL
1 vote162 views2 answers
Create a unqie constraint mysql
SQL
1 vote153 views1 answer
How to print longest name in sql
SQL
5 votes139 views1 answer
Oracle find foreign key dependencies
SQL
0 vote143 views1 answer
How to avoid duplicate records in sqlite
SQL