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

6 votes135 views4 answers
Eloquent to sql with bindings
SQL
0 vote148 views1 answer
Mysql streaming example
SQL
2 votes159 views1 answer
Oracle drop sequence if exists
SQL
3 votes157 views4 answers
Truncate syntax in sql
SQL
0 vote186 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
53 votes377 views6 answers
How to install mysql ubuntu
SQL
10 votes156 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote148 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote148 views1 answer
Set a default value for a column in sqlite
SQL
0 vote150 views1 answer
Mysql count with two joins
SQL