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

12 votes400 views6 answers
Change mysql root password
SQL
1 vote351 views1 answer
How to select random rows from a table
SQL
6 votes320 views2 answers
WHERE value IS sql
SQL
14 votes386 views6 answers
Finding duplicate rows mysql
SQL
2 votes322 views1 answer
Add 2 hours to current time in MySQL
SQL
13 votes316 views2 answers
Oracle inner join
SQL
1 vote316 views2 answers
Postgresql backup and restore globals and data
SQL
9 votes346 views4 answers
Oracle get table column names
SQL
11 votes336 views1 answer
Oracle view ddl
SQL
9 votes344 views5 answers
Laravel to sql
SQL