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 vote255 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote324 views1 answer
How to check foreign key constraint in sql
SQL
0 vote258 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote275 views1 answer
Sql output select
SQL
1 vote227 views2 answers
Get date from datetime postgresql
SQL
6 votes258 views4 answers
Eloquent to sql with bindings
SQL
0 vote282 views1 answer
Mysql last friday of current month
SQL
2 votes260 views1 answer
Oracle sql day of month from date
SQL
1 vote254 views1 answer
How refresh navicat tables to see new tables
SQL
1 vote261 views1 answer
Grab all records from one table to another oracle sql
SQL