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 vote254 views1 answer
Check if a column is a primary key in sql server
SQL
4 votes232 views1 answer
Add constraint fk
SQL
2 votes229 views2 answers
Mysql alter column default
SQL
0 vote218 views1 answer
Sql count * vs count 1
SQL
11 votes241 views3 answers
Pl sql example
SQL
16 votes232 views4 answers
Find duplicates mysql
SQL
0 vote231 views1 answer
Raven ql select count
SQL
1 vote227 views1 answer
Size of all tables in a schema oracle
SQL
1 vote235 views1 answer
Date_part mysql
SQL
39 votes242 views5 answers
Sql drop column
SQL