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

5 votes192 views2 answers
Oracle find all tables with column name
SQL
0 vote198 views1 answer
Rabbitmq ui not working
SQL
8 votes188 views2 answers
Mysql grant all privileges to user from any host
SQL
1 vote200 views1 answer
Isnull sql server
SQL
0 vote181 views1 answer
How to order result of subquery in select
SQL
0 vote194 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote184 views1 answer
Find all tables where column name exists oracle
SQL
0 vote186 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote193 views1 answer
Postgresql if else endif
SQL
1 vote210 views1 answer
Sql first
SQL