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 vote178 views1 answer
List all functions and procedures in postgres query
SQL
0 vote259 views3 answers
CONTACT FORM SQL
SQL
11 votes283 views5 answers
Update table from another table mysql
SQL
0 vote177 views1 answer
Android sqlite get rows count
SQL
2 votes208 views2 answers
Storing timezones in postgres
SQL
1 vote137 views1 answer
Oracle character set
SQL
1 vote252 views1 answer
Size of all tables in a schema oracle
SQL
3 votes221 views1 answer
Mysql cli connect with password
SQL
0 vote181 views1 answer
Sql dmv to capture updates
SQL
0 vote186 views1 answer
Sql query for select from specific columns in a table
SQL