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

1 vote254 views1 answer
Scaffold mysql database
SQL
2 votes249 views1 answer
Mysql list users on ubuntu
SQL
1 vote283 views1 answer
Sql view where tables have same column name combine results
SQL
1 vote259 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote276 views2 answers
Pad zero sql server
SQL
0 vote294 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote313 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote281 views1 answer
How do you insert boolean to postgresql
SQL
2 votes287 views1 answer
Dbms transaction (psql)
SQL
1 vote267 views1 answer
Insert column after column mysql
SQL