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

6 votes178 views5 answers
Get current date sql
SQL
0 vote260 views1 answer
Create table with timestamp mysql youtube
SQL
150 votes540 views10 answers
Grepper
SQL
0 vote209 views1 answer
This week mysql
SQL
24 votes189 views6 answers
Rename a column in sql server
SQL
0 vote237 views1 answer
Table structure in sql
SQL
4 votes228 views2 answers
Postgresql float data type
SQL
0 vote193 views2 answers
Sql update top 100
SQL
0 vote186 views1 answer
Oracle list proxy users
SQL
2 votes183 views1 answer
Mysql find tables with name
SQL