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 vote156 views1 answer
Play framework connection via windows sql server
SQL
0 vote140 views1 answer
Sql query to check if column contains alphabets
SQL
13 votes131 views2 answers
Check if value is null mysql
SQL
12 votes194 views2 answers
Update column data type postgres
SQL
3 votes139 views1 answer
Oracle sleep
SQL
0 vote189 views1 answer
Updating database in sql
SQL
0 vote149 views1 answer
Sql combine results from two tables
SQL
15 votes139 views4 answers
Mysql where value is null
SQL
1 vote136 views1 answer
Sql avg group by
SQL
-1 vote167 views1 answer
Sql vs nosql or mysql vs mongodb
SQL