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 vote247 views5 answers
Postgresql difference between two dates in days
SQL
3 votes181 views1 answer
Postgresql where current year
SQL
0 vote244 views1 answer
Alter domain sql
SQL
0 vote264 views3 answers
Mysql CAST(amount as float)
SQL
46 votes230 views4 answers
Create column sql
SQL
0 vote214 views1 answer
How to use group_concat in sql server
SQL
0 vote260 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
1 vote202 views2 answers
Limit sqlserver
SQL
2 votes220 views1 answer
Oracle kill job by sid
SQL
0 vote196 views1 answer
Select value from previous row in postgresql
SQL