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 vote320 views1 answer
Postgress append string in select
SQL
3 votes308 views1 answer
Oracle apex message quit website
SQL
0 vote319 views1 answer
Excute raw query
SQL
0 vote323 views1 answer
Mysql dump everythign
SQL
0 vote366 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
12 votes319 views5 answers
Sql primary key
SQL
2 votes318 views1 answer
Brew start postgres manual
SQL
1 vote325 views1 answer
Mysql view command
SQL
0 vote338 views2 answers
Default constraint in ms sql
SQL
0 vote308 views1 answer
Stop psql server windows
SQL