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 vote179 views2 answers
Plsql regex match whole word
SQL
0 vote179 views1 answer
Sql convert float to string
SQL
1 vote191 views1 answer
Importance of comment in mysql
SQL
0 vote175 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote186 views1 answer
Mysql db dump restore max file size issue
SQL
13 votes179 views2 answers
Check if value is null mysql
SQL
1 vote191 views1 answer
Wherein mysql
SQL
1 vote193 views1 answer
Update from select oracle
SQL
9 votes377 views2 answers
Current date in postgresql minus 1 day
SQL
2 votes203 views2 answers
Sqlalchemy return id after insert
SQL