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 vote130 views1 answer
Get employees if not contains in sql
SQL
1 vote136 views1 answer
Postgres concat_ws
SQL
2 votes131 views1 answer
Sql column values comma separated
SQL
0 vote132 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
1 vote129 views1 answer
Get table column names sql ssms
SQL
2 votes132 views2 answers
Sqlalchemy filter or
SQL
0 vote153 views1 answer
Sql injection payload list github
SQL
1 vote152 views1 answer
Mysql update inner
SQL
0 vote159 views2 answers
Wordpress change url after migration mysql query
SQL
10 votes124 views4 answers
Primary key in sql
SQL