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 vote313 views1 answer
What alter does in db
SQL
0 vote325 views1 answer
Get initials name in sql
SQL
1 vote312 views1 answer
Hexadec to sql REDSHIFT
SQL
0 vote259 views1 answer
Oracle sysdba connect as another user
SQL
10 votes318 views2 answers
Rtrim sql
SQL
0 vote276 views1 answer
Check sql query executed wp
SQL
0 vote327 views1 answer
Selecting Multiple Columns in SQL
SQL
-1 vote353 views1 answer
Get month and year from date in mysql sequelize
SQL
4 votes299 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote322 views1 answer
Uncheck constraints and delete from table
SQL