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

0 vote183 views1 answer
Raiserror with nowait
SQL
5 votes181 views3 answers
Oracle first day of last year
SQL
0 vote214 views2 answers
Postgres isnull
SQL
0 vote165 views1 answer
Mysql add root password
SQL
13 votes206 views3 answers
Mysqldump structure only
SQL
0 vote162 views1 answer
Postgresql regular expression special characters
SQL
1 vote178 views1 answer
Mysql is odd
SQL
6 votes170 views2 answers
Mysql set primary key
SQL
0 vote177 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote178 views1 answer
Mysql join only one column
SQL