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 vote146 views1 answer
Lesser than or equal to symbol in postgres
SQL
1 vote168 views1 answer
Alter constraint in sql
SQL
0 vote184 views1 answer
Mysql trigger to delete old data
SQL
0 vote154 views4 answers
Forenkey code alchemy sql
SQL
-1 vote205 views4 answers
Full outer join in sql
SQL
1 vote176 views1 answer
Mysql update inner
SQL
0 vote219 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote156 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote171 views2 answers
Sql query print strings and int
SQL
-1 vote155 views1 answer
Su: Authentication failure mysql
SQL