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

3 votes222 views2 answers
MySQL query to get column names
SQL
0 vote205 views1 answer
Where in clause tsql
SQL
0 vote205 views1 answer
Oracle c# multiple update sql
SQL
0 vote192 views1 answer
Csv to sqlite python
SQL
1 vote213 views1 answer
Where to locate set password for mysql
SQL
37 votes205 views3 answers
Duplicate records in sql
SQL
1 vote201 views1 answer
Delete from inner join sql
SQL
0 vote200 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote205 views1 answer
Laravel migration sql dump
SQL
1 vote196 views1 answer
Input in mysql
SQL