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

12 votes202 views1 answer
Script to add new column in table sql
SQL
0 vote205 views1 answer
Mysql master slave setup with keepalived
SQL
1 vote184 views1 answer
Nested if in mysql
SQL
0 vote197 views1 answer
Raiserror nowait sql server
SQL
0 vote232 views1 answer
Print intervals of 15 minutes in sql query
SQL
1 vote202 views1 answer
Random name function in mysql for nvarchar
SQL
11 votes194 views2 answers
Mysql set safe mode off
SQL
0 vote221 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
2 votes181 views2 answers
How to create an empty table from an existing table
SQL
3 votes230 views1 answer
Laravel paginate raw sql
SQL