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

4 votes100 views2 answers
Sql vs mysql
SQL
0 vote104 views1 answer
Change date in pivot table to month in sql server
SQL
1 vote122 views1 answer
Write a query to create an empty table from an existing table?
SQL
1 vote110 views3 answers
Sql union
SQL
0 vote97 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote92 views1 answer
Oracle 11g forget password
SQL
0 vote131 views1 answer
In query in sql
SQL
0 vote96 views1 answer
How to print out column name differently in mysql
SQL
19 votes107 views6 answers
What is mySQL
SQL
0 vote110 views1 answer
Create or replace view postgress
SQL