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 vote244 views1 answer
Sql server python connection
SQL
1 vote166 views1 answer
Table infromation in sql server
SQL
0 vote187 views1 answer
Postgresql heritage
SQL
0 vote191 views2 answers
Check mysql timezone
SQL
1 vote194 views1 answer
Oracle enable job
SQL
-2 votes242 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote213 views1 answer
Pgadmin save data greyed out
SQL
2 votes201 views3 answers
Sql interview query questions
SQL
0 vote177 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
49 votes315 views6 answers
Install mysql ubuntu
SQL