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

1 vote246 views2 answers
Oracle replace
SQL
0 vote261 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote252 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote262 views1 answer
Cross apply top for each row t1
SQL
0 vote243 views1 answer
Oracle search in date columns
SQL
2 votes264 views1 answer
Scaffold npgsql net core
SQL
2 votes250 views1 answer
Oracle trace session
SQL
3 votes240 views1 answer
Mysql set field unique
SQL
17 votes258 views3 answers
Postgresql version command
SQL
0 vote256 views3 answers
Create and attach user to a postgresql database
SQL