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 vote263 views2 answers
Delete auto increment mysql
SQL
1 vote290 views1 answer
Base nosql
SQL
5 votes305 views2 answers
Oracle apex debug mode
SQL
15 votes299 views3 answers
Find duplicate keys in mysql
SQL
0 vote322 views1 answer
Shows all databases created by user in ms sql
SQL
4 votes307 views1 answer
Search column by name mysql
SQL
0 vote381 views1 answer
Sqlite display headers on columns
SQL
0 vote283 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
1 vote311 views1 answer
Join first name and last name sql
SQL
0 vote308 views1 answer
Sql select all records from all tables where not empty
SQL