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 vote337 views2 answers
How to list all values of a column that start with a letter in sql
SQL
6 votes332 views5 answers
Get current date sql
SQL
0 vote342 views1 answer
Sql contains vs like
SQL
25 votes376 views6 answers
How to change column name in mysql
SQL
0 vote371 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
3 votes388 views2 answers
Truncate table
SQL
0 vote344 views1 answer
Windows services sql
SQL
0 vote350 views1 answer
Mysql export search results
SQL
15 votes347 views4 answers
How to get all tables in sql
SQL
0 vote336 views1 answer
Mysql trim characters
SQL