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 votes343 views1 answer
Oracle nextval
SQL
3 votes404 views2 answers
How to delete git repo locally
SQL
1 vote389 views1 answer
Table valued functions in sql
SQL
14 votes371 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
25 votes417 views1 answer
How to update an attribute in MySQL
SQL
0 vote341 views1 answer
Get first name and last name from full name string in SQL
SQL
3 votes365 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote398 views1 answer
Oracle insert single quote in string
SQL
2 votes393 views2 answers
Calculate percentage in sql
SQL
2 votes360 views1 answer
Mysql Incorrect column specifier for column
SQL