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

22 votes290 views3 answers
Year format in date mysql
SQL
7 votes265 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
50 votes393 views6 answers
Sql count duplicate rows
SQL
4 votes267 views3 answers
Oracle sql first day of quarter
SQL
6 votes259 views2 answers
Mysql check auto increment value
SQL
21 votes280 views1 answer
SQL cheat sheet pdf
SQL
0 vote250 views2 answers
Mysql get routine parameter list
SQL
4 votes257 views2 answers
Select first and last row mysql
SQL
0 vote252 views1 answer
Difference between 2 query results sql server
SQL
0 vote256 views1 answer
Sql file in postgres with pgadmin
SQL