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 vote263 views2 answers
Start mysql server using docker
SQL
0 vote234 views1 answer
What is ssrs and ssis in sql server
SQL
1 vote240 views1 answer
How to use a trigger to validate input data
SQL
1 vote238 views1 answer
Oracle activate job
SQL
5 votes229 views1 answer
Oracle columns in all_tables
SQL
5 votes252 views2 answers
Sql constraint check value in list
SQL
0 vote236 views1 answer
Delete data from database sqlite android
SQL
0 vote238 views1 answer
Postgresql print variable
SQL
0 vote240 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote189 views1 answer
Hangfire clean script
SQL